counif but not all the cells
 

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

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

--
HTH

Bob Phillips

"thanks" wrote in message
...
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

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.

thanks wrote:
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.a...tions/200507/1