countif with a segmented range
 

Is there an easy way to do a countif with the data in question in every
second column?
The function might look like =countif(A3,C3,E3,"RED")

countif with a segmented range
 

=SUMPRODUCT(--(A3:A8="red"),MOD(ROW(A3:A8),2))

Counts every other row and if it is "red"

--
Wag more, bark less


"Allan" wrote:

Is there an easy way to do a countif with the data in question in every
second column?
The function might look like =countif(A3,C3,E3,"RED")

countif with a segmented range
 

The function might look like =countif(A3,C3,E3,"RED")

If the range is only a "few" cells:

=(A3="red")+(C3="red")+(E3="red")

If the range is more than a "few" cells:

=SUMPRODUCT(--(MOD(COLUMN(A3:E3)-COLUMN(A3),2)=0),--(A3:E3="red"))

--
Biff
Microsoft Excel MVP


"Allan" wrote in message
...
Is there an easy way to do a countif with the data in question in every
second column?
The function might look like =countif(A3,C3,E3,"RED")