Prev: countif with time
Next: exclude certain cells from series fill
From: edk on 27 Jan 2010 08:57
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 27 Jan 2010 09:53
=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?
 | 
Pages: 1
Prev: countif with time
Next: exclude certain cells from series fill