UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Sum of Colored Cells?    
 
   
Burty
post Aug 16 2005, 10:43 PM
Post #1

New Member
Posts: 2
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.
Go to the top of the page
 
+
freakazeud
post Aug 16 2005, 10:47 PM
Post #2

UtterAccess VIP
Posts: 31,413
From: NC, USA
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
Go to the top of the page
 
+
Burty
post Aug 16 2005, 11:36 PM
Post #3

New Member
Posts: 2
Thank you Freakazeud,

Works just fine for me.
CU,

Burty
Go to the top of the page
 
+
freakazeud
post Aug 16 2005, 11:37 PM
Post #4

UtterAccess VIP
Posts: 31,413
From: NC, USA
You're welcome.
Glad I could assist.
Good luck on future projects!
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 10:29 AM