From: edk on
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?
From: Teethless mama on
=SUBTOTAL(9,A2:A100)

Select your range > Data >Filter >Filter by color


"edk" wrote:

> 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?