Quote Originally Posted by argomike View Post
Pete,

How would I adjust the cell allocations in order to accomplish my goal of totaling rows from multiple areas of the sheet? I'm not sure what I'd have to edit from your formula.
It would help if you described your data layout - in your first post you said you had 10,000 rows!

With my formula you are counting the number of rows in the range and subtracting from that the rows that have all three cells blank, so applying my formula to the ranges that OnError has used, you would have this:

=ROWS(A7:A32)-SUMPRODUCT((I7:I32="")*(J7:J32="")*(K7:K32="")) + ROWS(A36:A80)-SUMPRODUCT((I36:I80="")*(J36:J80="")*(K36:K80="")) + ROWS(A84:A109)-SUMPRODUCT((I84:I109="")*(J84:J109="")*(K84:K109=""))

Hope this helps.

Pete