Ask Your Question
0

Count cells with "minus value" [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2021-05-10 21:07:57.631451

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

Question Tools

1 follower

Stats

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

Seen: 190 times

Last updated: May 22 '18