Sum a range of Data that's not shaded gray

  • Thread starter Thread starter Pete C.
  • Start date Start date
P

Pete C.

Hi,

I trying to figure out how to SUMIF only if the data in a cell is not shaded
gray.

On my spreadsheet, once an item in a column is shaded gray, it is complete.
If it is shaded any other color it is an accounts receivable. So I'm trying
to figure a quick way to add up my accounts receivables.

Any ideas would help...Thanks..Pete
 
Back
Top