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