I'm new here and need your help.
I have to use sumifs in macro for two conditions, one condition is based on font color. ( sum total based on both text and font color)
is there a way of defining font color index as condition criteria for sumifs?
thanks very much
2011 2012 2013
a 55 55 55
a 1 2 3
b 2 4 6
2011
TotalBlue a 55
TotalBrown a 1
TotalBrown b 2
Bookmarks