=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

-----Original Message-----
i need to make a function that will allow me to add bag
counts only for the ones with "yes" and divide that by
the
total bag count and get a percentage for an answer at the
bottom of the LOCAL JOB column. based on my example below:

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

TOTAL ??% 900

Thanks in advance to anyone who can help.

Kim
.