Countif for non-continuous data

Hi there,

I'm looking for a method for counting the number of cells in a non-continuous range of cells which meet simple conditions, countif does not work, and using a sum of countif's is a bit of a poor method, is there a better way?

What are the ranges, is there a pattern, e.g. A1:A4, C1:C4, E1:E4 or similar?

There would be various ranges:

But the first one I was trying to use was D3, G3, J3, M3, P3.

Try the following formula, which needs to be confirmed with CONTROL+SHIFT+ENTER...

=SUM(IF(MOD(COLUMN(D3:P3)-COLUMN(D3),3)=0,IF(D3:P3=A2,1)))

...where A2 contains the criteria.

Hope this helps!

Perfect,

thanks