Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 8th 08, 04:15 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 2
Default Summing cells within a column based on cell fill color

I'm trying to sum cells within a single column based on the cell fill color.
There will be a maximum of three individual colors. I'm assuming this
something with either the SUMIF or SUMIFS function, but can't quite get there.

Thanks,

Jim D.

  #2   Report Post  
Old October 8th 08, 04:22 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Summing cells within a column based on cell fill color

See:

http://www.cpearson.com/excel/Colors.aspx


--
Gary''s Student - gsnu200806


"Jim D." wrote:

I'm trying to sum cells within a single column based on the cell fill color.
There will be a maximum of three individual colors. I'm assuming this
something with either the SUMIF or SUMIFS function, but can't quite get there.

Thanks,

Jim D.

  #3   Report Post  
Old October 8th 08, 04:56 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 16
Default Summing cells within a column based on cell fill color

Thank You. Pretty intense for an Excel intermediate, but I'll try to figure
it out.

Jim D.

"Gary''s Student" wrote:

See:

http://www.cpearson.com/excel/Colors.aspx


--
Gary''s Student - gsnu200806


"Jim D." wrote:

I'm trying to sum cells within a single column based on the cell fill color.
There will be a maximum of three individual colors. I'm assuming this
something with either the SUMIF or SUMIFS function, but can't quite get there.

Thanks,

Jim D.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reference a cell based on Fill color? Arlen Excel Discussion (Misc queries) 3 July 19th 08 06:04 AM
How do you fill a cell with a color based on IFTHEN formula? ctbowling Excel Worksheet Functions 1 May 9th 06 04:11 PM
Is there a way to count cells in a range based on fill color? eehinmd Excel Worksheet Functions 2 March 16th 06 05:09 PM
Fill cells with color based on criteria in two cells AA Excel Worksheet Functions 2 January 2nd 06 11:29 PM
color fill cells based on IF function or formula Victor Jones Excel Worksheet Functions 1 November 23rd 05 03:17 PM


All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017