counif but not all the cells

[Guest]

How can I count just some cells in the same row that have a condition?

ex:

A B C D E F
1 8 7 3 7 10

It should just count cells B, D and F and the condition is that the value
should be >=7

 

[Bob Phillips]

=SUMPRODUCT(--(MOD(COLUMN(1:1),2)=0),--(1:1>=7))

 

[Mark B via OfficeKB.com]

in column H let's say, you could enter:
=countif(B1:B13,">6")+countif(d1:d13,">6")+countif(F1:F13,">6")

of coure the values 1 (as in B1) and 13 (as in B13) can be any value at all
and were chosen only for exapmle.

How can I count just some cells in the same row that have a condition?

ex:

A B C D E F
1 8 7 3 7 10

It should just count cells B, D and F and the condition is that the value
should be >=7

--
Mark Brindamour
mtbrindamour[AT]hotmail[dot]com


Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200507/1