I have a workbook that has about 230 rows of data. Three lines for
every name. On the third of the three lines is an average of the two
rows above it.
in C234:O234 i have a row that is titled "Percent Monitored". when it
used to be very small, i had the following formula in these cells:
=COUNTA(C4,C7,C10,C13,C16,C19,C22,C25,C28,C31,C34, C37,C40,C43,C46,C49,C52,C55,C58,C61,C64,C67,C70,C7 3,C76,C79,C82,C91)/COUNTA(A4:A91)
This gave me the number of audits divided by the number of names in
Column A. Now, i have way too many rows to do this. What would be an
easier way to determine teh amount of monitors (keep in mind that every
three rows is an average row of the two previous rows) divided by names
in Column A?
Thanks.
--
ForSale
------------------------------------------------------------------------
ForSale's Profile:
http://www.excelforum.com/member.php...o&userid=11896
View this thread:
http://www.excelforum.com/showthread...hreadid=277223