Sumif with Conditionale formatting of a cell

C

Chuck

I need to use sumif but only count the cells that are shaded blue. The blue
cells are subtotals that I don't want re-counted.
Thank you,
Chuck
 
D

David Biddulph

If they are shaded by CF, include the CF condition in your SUMIF conditions.
If they are shaded by ordinary formatting, you'll need VBA to do the job.
 
Top