count a range of cells as one if there is at least one value

[juliangun4ev]

Hello guys,

I'm stuck once again
Could you help me pls.
I have different sectors. (a1:c1 / a2:c2 / a3:c3 etc..) What i need to do is to count the values but not all.
If in one cell in this sectors there is value i just want to count it as 1 no mettar if the other cells in this sector are empty or not.

Thank you vey very much!!

[ragulduy]

Maybe you could try something like:
=SUM(IF(NOT(ABS(A1:A3)+ABS(B1:B3)+ABS(C1:C3)=0),1,0))
it's an array formula so needs to be confirmed with ctrl+shift+enter.
It's set up for your example of sectors a1:c1, a2:c2 and a3:c3 but if you want to extend for more rows you can change the 3 to your total number of rows and it should still be ok.