View Single Post
  #1   Report Post  
Dave H
 
Posts: n/a
Default SUMIF on Fill color

Is it possible to use SUMIF or similar to sum cells where the Fill Color is
Yellow for instance ??

IE something along the lines of =SUMIF(C3:C15),"FillColor=Yellow",C3:C15)
......

At present I'm getting along by adding a separate column which has an
asterisk in it and using that as the basis for the SUMIF, but I'd rather
just change the cell colour to select the amounts I'm interested in.

Thanks Dave H.