ExcelBanter - how do I sumif on a font color in excel 2007?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do I sumif on a font color in excel 2007? (https://www.excelbanter.com/excel-worksheet-functions/254594-how-do-i-sumif-font-color-excel-2007-a.html)

edk

how do I sumif on a font color 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?

Teethless mama

how do I sumif on a font color in excel 2007?

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

All times are GMT +1. The time now is 04:09 AM.