Try this: =(SUMIF(B10:B12,"yes",C10:C12))/C13

Where B Column is your "Local Job" colum and the 10 & 12
are your starting & ending row #'s. The "C" column is
your BAG COUNT column. That final "C13" should be the
cell where your "900" resides. You will also have to
format the cell in the end so that it yields a percentage
(You can do that by pressing Ctrl+1, when in that cell and
then selecting "Percentage" in the "number" tab.

Essentially, the formula says, "look at the column B, and
if that column has a "yes" in it, sum the corresponding
value in column C.

Hope this helps,
Jamison


-----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
.