See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"NoviceLois" wrote in message
...
I have a large spreadsheet where certain rows are colored red. I would
like
to sort on one column, then total the number of red rows in that group as
well as obtain a grand total of the number of red lines. How do I
accomplish
this?

Thank you in advance for your help to an Excel novice.