Countif formula

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

Daniel Bonallack

I have values in all cells from A1 to P1.
I'd like a formula (in Q1) which counts how many of jsut
cells E1, J1, and P1 are greater than zero (so my answer
will be either 0,1,2 or 3.

Thanks in advance

Daniel
 
It would be easier if it was some sort of rule like every 5th cell but since
it is 6 steps between J and P it won't work. But since there are so few
cells you can use


=SUM((E1>0),(J1>0),(P1>0))

If there were many cells you could first select them one by one and then do
insert>name>define and give them a name and use a formula like


=SUMPRODUCT(--(LARGE(MyName,ROW(INDIRECT("1:"&COUNT(MyName))))>0))
 
Daniel Bonallack said:
I have values in all cells from A1 to P1.
I'd like a formula (in Q1) which counts how many of jsut
cells E1, J1, and P1 are greater than zero (so my answer
will be either 0,1,2 or 3.

=SUM(E1>0,J1>0,P1>0)
 
Back
Top