Calculations based on cell colour

Stewie

New member
Joined
Aug 6, 2012
Messages
7
Reaction score
0
Points
0
Hi,
I have a spread sheet which uses conditional formating to turn a cell colour red if the customer is overdue on payment.

Is there a way of adding the values in the red cells only?


Regards,
Stewie
 

k0st4din

New member
Joined
Aug 7, 2012
Messages
6
Reaction score
0
Points
0
Location
BG, London
Hi,
Could you clarify what exactly you want to get? From what you write, I understand that you have your cell only red or ...................?
 

Stewie

New member
Joined
Aug 6, 2012
Messages
7
Reaction score
0
Points
0
Hi, I am using conditional foramting to change cell colours to "red", late payment, "yellow" payment not due, "green" paid, "blue" invoice needs to be raised, not sent.

I am looking to add the values stated in the red cells only,

Regards,
Steve
 

Zack Barresse

Super Moderator
Staff member
Joined
Mar 16, 2011
Messages
112
Reaction score
0
Points
0
Location
Oregon, United States
Excel Version(s)
365, Online, iOS, iOS for iPad
Hi there,

No, there is no native way to do this. You could use VBA if you wanted, but it would seem easier to use a formula based on the same criteria as your conditional formatting...

Code:
=SUMIF( RangeToLookAt, Criteria, RangeToSum)

i.e.
=SUMIF(A1:A10,"late payment",B1:B10)
The example will look at A1:A10, and for each value where it equals "late payment" it will sum the adjacent value in B1:B10.

HTH
 
Top