Sumif with Conditionale formatting of a cell

[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

 

[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.