CountIF

[stevewilde]

How can I minus 1 from this COUNTIF. Basically counting non blanks - but it keeps counting the title as well, even when i change it to start at row D2 (it just jumps back to D1 next time)

=COUNTA(RAW_DATA_2!$D$1:$D$215)

Thanks

[zbor]

=counta(raw_data_2!$d$1:$d$215)-1

[Ron Coderre]

This formula will ignore cell D1 and return the count of non-blank cells in D2:D215:

Please Login or Register  to view this content.

Does that help?

[stevewilde]

That was so simple - thanks guys!!

[NBVC]

Isn't that what you said you tried?

even when i change it to start at row D2 (it just jumps back to D1 next time)