View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Summing a column

Why are some numbers green and some red?

Write the formula based on *why* the numbers are the color they are.

--
Biff
Microsoft Excel MVP


"Rooky228" wrote in message
...
I have a column of numbers - some with different colors. I'd like to sum
just the green or the red, etc. How do I write a formula that somes only
certain colors?

Thanks,
Curt