|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 7th, 2010, 05:39 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
sumif color cells with same month
My file have two columns A - Month B - Amount
I will change the color to red of certain cells in column B Can I use the sumif function to total column B of those cells with same month and color red ? Many thanks eva cheng 
|
|
#2
May 7th, 2010, 06:45 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif color cells with same month
You can't sum by color (is there some criteria you could use, such as
greater than x value?), but you can sum by month like this: =SUMPRODUCT(--(TEXT(A2:A100,"mmm")="Apr"),B2:B100) -- Best Regards, Luke M "eva cheng" wrote in message ... My file have two columns A - Month B - Amount I will change the color to red of certain cells in column B Can I use the sumif function to total column B of those cells with same month and color red ? Many thanks eva cheng
|
|
#3
May 7th, 2010, 07:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif color cells with same month
Dear Eva,
Yes you can. For "sumif" function it's necessary however that in addition to coloring the cells you add an additional cell with the color name. See for further details: http://www.officearticles.com/excel/...ft_excel.h tm Hope to have helped  Rgrds, Kristiina -- I help with Excel and PowerPoint Office ToDo http://www.officetodo.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
