tsaal

I have some conditional formats in place that change the fill color in several columns. I am having difficulty trying to "countif" and "sumif" based on a fill color that results from a conditional format. Any help in this matter would be GREATLY appreciated.

italkid

You could use a SUMIF or SUMPRODUCT formula to perform calculations based upon the same criteria as you use for the conditional formatting.

tsaal

Thanks for your reply.
Each cell that I need to count/sum has different calculations based on dates. If the date is "within 30 days" the conditional formatting sets the cell shade to yellow. When it's past due, the conditional formatting sets the cell shade to red.
What I am in hopes of doing is to count/sum if for those that are past due based on the shade of the cell being red. Same for those within 30 days... sumif cell shade is yellow.
This is not something I have seen before, so I am in hopes that someone has a suggestion.

italkid

Ok, I have now idea how your data looks like, but my idea was to use something like this.... see attachment.