countif
 

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


--
maryj

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

-----Original Message-----

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


--
maryj
.