sum cell values by criteria there cell color (Excel Mac 2011)

Hi
It's easy, except you need to tell your formula what you mean by "Red"! there are thousands of RGB combinations that look "red"

if you are using the microsoft default red RGB(255,0,0) then this user-defined formula should work (or if you know the RGB of the colour your are using, use this instead of FontColour = RGB(255, 0, 0))

Please Login or Register  to view this content.

if not, try this formula. The first cell to enter has the font colour you want to count, the range includes the cells whose values you want to sum. So to count cells in B1:F1 with the same font colour as A1, Your formula will look like this

=Function colours_add_match_first(A1,B1:F1)

Please Login or Register  to view this content.

you really need to make those functions volatile. they still won't react to simply changing a cell color but at least they will update when the workbook calculates ;-)

of course not using color as data is better