counif but not all the cells

T

thanks

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
 
M

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
Click to expand...

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


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