Glad the solutions provided by Tyla and Art worked
for you. Thought the following might be of further
help in finding and using additional Worksheet Functions
you are not familiar with. In addition to Excel's own Help.

For help in finding and using formulas you might take a look at
Excel Function Dictionary , by Peter Noneley
with 150 example functions and formula.
http://www.hoffits.com/xlfdic/index.html

You might find my page also of interest concerning
Summarizing Data Examples (an Overview)
http://www.mvps.org/dmcritchie/excel/sumdata.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"mygirls2_ae" wrote...
Tyla and Art

Thank you very much. The "COUNTIF" function worked.
I had never used that before. Thank you again.
--
mother of 4