countif

M

maryj

I have a client that needs to do a countif. The problem is is that th
range is not consecutive cells. For example the range may be C3, E3, G
but not including D3 or F3. How can this be done
 
B

Biff

Hi!

Based on you example (but I have a feeling that you will
change it after I've posted this! <g>)

=SUMPRODUCT(--(MOD(COLUMN(C3:G3),2)=1),--(C3:G3="a"))

Replace "a" with your criteria. Use the quotes if it's a
TEXT value. Do not use the quotes if it's a numeric value.

Biff
 
Top