To the three of you who answered, thank you. I failed to give some important
info, however, and even wonder if this is now possible.

(I did try the various formulas that each of you supplied, and that is where
I discovered my error.)

The #s that I need to count in col. H are only if they're Open docs (listed
in col. G) so I need to weed those #s out from the Closed or N/A docs in G.

Does that make sense? And is that possible?
--
FlorencePS
Intermediate to Advanced User


"FlorencePS" wrote:

Hi. I've got a spreadsheet that has conditional formatting in one column as
follows:

1-14 days - green
15-30 days - yellow
over 30 days - red

I need to be able to have each color total up into three different cells,
meaning, 3 green, 10 yellow, 31 red. Is there a formula to do that
automatically?

Thank you for any assistance.
--
FlorencePS