the first formula counts all the completed items, the second part counts all the items in column A. It then deducts 8 for the 8 total averages.
i would like to know how i can create a formula that will pick up all the items that have the "total averages" automatically without me having to change it manually. Every time I add lines and new total averages are created I have to change it manually. I would love for the formula to pick up the cells with the total averages only please...................
there is a complete row.....A12, B12,C12, D13 all are the total averges..exp.....

=COUNTIF(B13:B2071,"Completed")/(COUNTA(C13:C406)-8)


i tried this one on the bottom and it gave me a total of 4 not 8? why???
there are 8 cells with the total avg. please help...


=COUNTIF(A1:A209,"Totals/Avg")





thank you,
cathy

cathy_andujar@yahoo.com