Ged Traynor
Board Regular
- Joined
- Oct 12, 2007
- Messages
- 73
Hi All
Is it possible to use countif on multiple ranges, the formula I'm using at the moment is =COUNTIF(H1:H210,"Long"), which will only count column h
What I would like to now can I use countif to count through multiple columns
Something like
=COUNTIF(H1:H210,J1:J210,"Long")
Hope this makes sense
Thanks in advance
Ged
Is it possible to use countif on multiple ranges, the formula I'm using at the moment is =COUNTIF(H1:H210,"Long"), which will only count column h
What I would like to now can I use countif to count through multiple columns
Something like
=COUNTIF(H1:H210,J1:J210,"Long")
Hope this makes sense
Thanks in advance
Ged