Thread: Sum Formula to Exclude Certain Cell Values/Backgrounds
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phil Hageman[_4_] Phil Hageman[_4_] is offline
external usenet poster
  
Posts: 81
Default Sum Formula to Exclude Certain Cell Values/Backgrounds
Incell range W15:W31, percent values are font/background-color conditional
formatted.

In cell W10 is the following formula: =SUM(X15:X31)

What would the formula be to exclude in the sum, a cell having a green
background and a zero percent value?

Reply With QuoteReply With Quote