Prev: Extract unique data
Next: Moving certain data to different sheet
From: eva cheng on 7 May 2010 12:39
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
From: Luke M on 7 May 2010 13:45
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" <evacheng(a)discussions.microsoft.com> wrote in message
news:769CE3C9-1043-4D16-B872-E80B07E47C73(a)microsoft.com...
> 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


From: Kristiina on 7 May 2010 14:00
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/sumif_using_multiple_criteria_in_microsoft_excel.htm


Hope to have helped :)

Rgrds,
Kristiina

--
I help with Excel and PowerPoint
Office ToDo
http://www.officetodo.com

 | 
Pages: 1
Prev: Extract unique data
Next: Moving certain data to different sheet