E edk Jan 27, 2010 #1 I would like to do a conditional sum of a color coded column of numbers. Is there any way to do that in Excel 2007?
I would like to do a conditional sum of a color coded column of numbers. Is there any way to do that in Excel 2007?
T Teethless mama Jan 27, 2010 #2 =SUBTOTAL(9,A2:A100) Select your range > Data >Filter >Filter by color
