COUNT IF non blank

[Glacombe]

Hello,

I have a formula that counts the amount of people for a certain range. The columns and rows are for example, C6:C9,F6:F9,I6:I9,L6:L9,O6:O9, and all those cells have already a formula. I would like to add only those with data in it and not the blanks. Right now it counts the cells with the formula also, even though the cell is blank.

So what would the formula would be?

Thanks

 

[floppygoat]

What is the formula in the cells?

 

[Glacombe]

What is the formula in the cells?

This is the formula in all the cells
=IFERROR(INDEX('List of Ex1-5'!$B$2:$B$136,AGGREGATE(15,6,(ROW('List of Ex1-5'!$B$2:$B$136)-ROW('List of Ex1-5'! and the formula to count the results is

=COUNTA(C6:C9,F6:F9,I6:I9,L6:L9,O6:O9,R6:R9,U6:U9,X6:X9,AA6:AA9,AD6:AD9)

 

[floppygoat]

The first formula doesn't appear to be complete?

 

[Glacombe]

Oops so sorry, the second line was hidden, here it is

=IFERROR(INDEX('List of Ex1-5'!$B$2:$B$136,AGGREGATE(15,6,(ROW('List of Ex1-5'!$B$2:$B$136)-ROW('List of Ex1-5'!$B$2)+1)/('List of Ex1-5'!$A$2:$A$136="CMB")/('List of Ex1-5'!$D$2:$D$136="EX-03"),ROWS(A$1:A1))),"")

 

[floppygoat]

Did you try COUNT without "A" instead?

=COUNT(C6:C9,F6:F9,I6:I9,L6:L9,O6:O9,R6:R9,U6:U9,X6:X9,AA6:AA9,AD6:AD9)

 

[Eric W]

How about:

=SUMPRODUCT((C6:AD9<>"")*(MOD(COLUMN(C6:AD9),3)=0))

 

[srehman]

Simple count with your ranges will work

 

[Glacombe]

Did you try COUNT without "A" instead?

=COUNT(C6:C9,F6:F9,I6:I9,L6:L9,O6:O9,R6:R9,U6:U9,X6:X9,AA6:AA9,AD6:AD9)

Good morning

If I remove the "A" I get 0 as a result

 

[Glacombe]

Thanks E

How about:

=SUMPRODUCT((C6:AD9<>"")*(MOD(COLUMN(C6:AD9),3)=0))

Thanks Eric that one did work