need help with a function

[Kerry Bennett]

=SUMIF(B5:B7,"yes",C5:C7)/SUM(C5:C7)

JOB NAME LOCAL JOB BAG COUNT
pool yes 100
gym no 300
school yes 500

TOTAL 67% 900


regards,
Kerry Bennett
www.excelaid.com