Sum positive and negative numbers seperately (GOOGLE SHEETS)

[rayted]

Hi all,

Here is my sheet: See the tab called top line

https://docs.google.com/spreadsheets...it?usp=sharing

Looking at my spreadsheet

You can see in cells E3 and E4 there are amounts in the negative. This means I am owed money.

For cells I2, I3, I4 and I5, the numbers are positive. Which means there is money in the kitty.

How do I write a formula to add what is in the kitty (positive numbers) and a seperate formula to add what is owed (negative numbers)

I have tried the SUMIF in google sheets to no avail. I guess I need 2 cells with 2 formulas.

1 cell to calculate the sum of: (E2:E6,I2:I6,M2:M6,E10:E13,I10:I14,M10:M14,Q10:Q14) the numbers which are + (positive) = this tells me what is money for the kitty (i.e there has been left over money) and I need another cell with the formula for (E2:E6,I2:I6,M2:M6,E10:E13,I10:I14,M10:M14,Q10:Q14) to calculate the number of - (negative) numbers = this tells me what I am owed/has not been paid to me yet. Even if the result is -£20 for example.

Hope this makes sense!



Thank you

 

[RoryA]

Please read the forum rules on cross-posting and provide the relevant links here. Thanks.

 

[rayted]

Please read the forum rules on cross-posting and provide the relevant links here. Thanks.

I`m sorry Rorya

I dont understand what I did wrong? can you please explain and i`ll ensure i dont do it again. sorry

 

[RoryA]

Which part of the rule did you find unclear?