Multi-Column Counting - COUNTA or other Options

Originally Posted by OnErrorGoto0

FYI, here is Haseeb's sheet with my formula beneath his.

I've taken OnError's sheet and put my formula below his.

Hope this helps.

Pete

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.

Originally Posted by Pete_UK

I've taken OnError's sheet and put my formula below his.

Hope this helps.

Pete

Originally Posted by argomike

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