Right now, I have a SUMIF function that works fine:

=SUMIF(G12:G54,"SUBTOTAL",M12:M54)

I've never seen this before, but is there a way to build cell color into a formula? For instance, in the equation above, I would only want to sum the cells in M12:M54 that were NOT highlighted yellow.

Will I have to resort to VBA to do this?

Thanks in advance,
JChandler22