J
Jamison
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
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