You're very welcome.....I'm glad I could help.

Regards,

Ron
Microsoft MVP (Excel)


"AFJr" wrote in message
...
Ron,

You are a godsend! Yes that worked beautifully. I was ready to move on and
try something else but really had no idea.

Again, I really appreciate you sticking with me, trying different things
and
such. Helping me to open my mind. I love user groups, a place to give help
and get help.

Thanks again Ron,

Have a great weekend!

AFJr


"Ron Coderre" wrote:

It's time to try another approach:

Try this ARRAY FORMULA (committed with CTRL+SHIFT+ENTER,
instead of ENTER):

=SUM(IF($B$21:$B$62="C",IF(ISNUMBER($Q$21:$S$62),$ Q$21:$S$62)))

Does that help?
-------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)