A shorter alternative to IF formula

[Usercode]

Is there a shorter way of doing this? please.

=IF(AND(A1>0,A2>0),1,0)+IF(AND(B1>0,B2>0),1,0)+IF(AND(C1>0,C2>0),1,0)

Basically, if A1 and A2 are greater than 0 at the same time, it should be counted as "1", if not 0, and then all results in the range are summed.

My data are like this:

13 17,2 7,6
22,23 14 9
11,22 14



Thank you.

 

[Usercode]

I wanted to decide to shorten if formula because the data is bigger than the example. but I can write it, it will be a long formula only.

 

[Twollaston]

did you try this
=SUMPRODUCT((A2:C2>0)*(A1:C1>0))

I noticed in the example c2 is blank, but =isblank(c2) is FALSE does that mean you filled this one with a formula?

see this
Compared A3 with C2 both are blank and returning different answers. Is your normal data set like this too?

Book1
	A	B	C	D	E	F	G	H
2	22,23	14		9		1	FALSE	TRUE
3		11,22	14			0	TRUE	FALSE
Sheet1

Cell Formulas
Range	Formula
F2	=IF(C2>0,1,0)
F3	=IF(A3>0,1,0)
G2	=ISBLANK(C2)
G3	=ISBLANK(A3)
H2	=ISTEXT(C2)
H3	=ISTEXT(A3)

 

[Usercode]

Thanks, Twollaston. This formula works in my case. and it is a lot shorter. Thanks a lot!

 

[Usercode]

No, currently there is no formula. I think I made a mistake there.
Yes my dataset is like this. With commas, but not all numbers.

 

[Twollaston]

Thanks, Twollaston. This formula works in my case. and it is a lot shorter. Thanks a lot!

No problem, happy to help you. Thanks for the feedback