Ask Your Question
0

Formula syntax [closed]

asked 2013-11-07 11:56:16 +0100

Resi gravatar image

hi All could someone help please. I am setting up a spreadsheet, and in column a I have both positive and negative figures. I want to but in a cell the sum for the positive values and in another cell the sum of all the negative values, but can't figure out the syntax.

can anyone help please?

thanks, R

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 2015-11-13 05:43:35.058685

2 Answers

Sort by » oldest newest most voted
0

answered 2013-11-07 12:41:34 +0100

erAck gravatar image

=SUMIF(range;"<0")

=SUMIF(range;">0")

edit flag offensive delete link more
1

answered 2013-11-07 12:43:57 +0100

B.Horvat gravatar image

updated 2013-11-07 12:45:27 +0100

=SUMIF(A2:A8;">0") for positive numbers and =SUMIF(A2:A8;"<0") for negative numbers in example range A2:A8

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-11-07 11:56:16 +0100

Seen: 127 times

Last updated: Nov 07 '13