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.
--
David Biddulph

"Chuck" wrote in message
...
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