Hey guys,

Coming to the guru's again. I'm looking to sum the numbers in my cell range based off a particular color and ignore the cell if there is a date.

Data is in B3:S3 and the color is Olive Green, Accent 3. The cell where I'm summing is T3.

This is probably too simple. I thought I could do it with conditional formatting, but haven't figure it out.


Thanks in advance.