count colored rows

[NoviceLois]

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.

 

[Bob Phillips]

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

--

HTH

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