Full Version: Sum of Colored Cells?
UtterAccess Discussion Forums > Microsoft® Office > Microsoft Excel
Burty
Hello everyone,


Can anyone say me if it is possible to make a sum of the values entered in cells with the same background color? I never found a way to do it in any manual, but it would be pretty useful to me if I could. I was thinking it should be posible using the formula SUMIF, but I do not have a reference of the background color to refer to. Or does anyone have a better idea?
Thanks,

Burty.
freakazeud
Hi,
welcome to UA forums.
Check one of these:
sum by fill color
sum by fill or background color
sum by background color 01
HTH
Good luck
Burty
Thank you Freakazeud,

Works just fine for me.
CU,

Burty
freakazeud
You're welcome.
Glad I could assist.
Good luck on future projects!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.