sum cells depending on colour

[Reasteh]

Hi,

Got a spreadsheet with values in red and blue

i want to sum anything thats blue in a cell and anything thats red in another cell

i'm guessing this is probably easy but im a noob

 

[Bint Box]

Hi,

Got a spreadsheet with values in red and blue

i want to sum anything thats blue in a cell and anything thats red in another cell

i'm guessing this is probably easy but im a noob

Are your red values negative numbers and the blue values positive numbers? If this is the case, you can sum using <0 and >0 as conditions.



Rgds
Binty

 

[Bint Box]

Hi,

Got a spreadsheet with values in red and blue

i want to sum anything thats blue in a cell and anything thats red in another cell

i'm guessing this is probably easy but im a noob

Alternatively, you can use a function such as DSUM or possibly some type of IF statement to test the cell value and only sum if positive or only sum if negative.

I think you need to elaborate a bit on your original request.


Rgds
Binty