Google sheets - sum by colour

[UnsuccessfullyAdulting]

Hello! I'm desperate for a formula which sums all cells which th a certain text or background colour. I can conditionally format either by text or background colour, but I need to add all cells with a

[DanFmDorking]

It's not too clear what you are asking for but -

With this column of data in column 'A':-

2
-1
3
-7
4
-9

=SUM(A1:A6) adds all the numbers

=SUMIF(A1:A6,"

[DanFmDorking]

Oooops, there is a typing error

=SUMIF(A1:A6,">0") adds all the positive numbers

[UnsuccessfullyAdulting]

Dan I nailed it with that formula. Thanks so much! You've saved me about 3 hours a week at work!