Thread: how do I sumif on a font color in excel 2007?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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?
Reply With QuoteReply With Quote