Ask Your Question
0

Count cells with "minus value"

asked 2018-05-22 17:25:01 +0200

unknown1001 gravatar image

How count all cells in row with minus value like -9 -4 -2 and how count in the same row with plus value 3 2 5 8? i need count cells not SUM

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2018-05-22 17:44:08 +0200

JohnSUN gravatar image

As shown in the examples to this article, you can use such formulas

=COUNTIF(1:1;"<0")
=COUNTIF(A1:M1;">0")
=COUNTIF(A1:AMJ5;0)
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-22 17:25:01 +0200

Seen: 32 times

Last updated: May 22 '18