Peo Sjoblom/RagDyer:

YOU DID IT. It Works..!. I found some stray "n/a's" ,
with the Find function. It's a huge worksheet. Ajusted
RagDyer's formula. It works. Can't thank you guys
enough. Your help was very much appreciated.
This is a Terrific Site! Excel PROS..
Thank you.
Sincerely, Lovella

Lovella wrote:
RagDyer:

Thanks for the rsponse... it didn't work.. same "VALUE! error.
I'm thinking, the IF Then Else.. formula.. If cell =text ignore..
Else Add. something like that but I don't know how to do it.
It may take a VB program. but I'm just learning that.
Thanks again for trying. Lovella

Try this:

=SUM(BZ864,CB864:CF864,CA864*BZ864)

I'm working for a company auditing excel worksheets
I have a worksheet with the following formula,
[quoted text clipped - 8 lines]

Thanks in advance, Lovella

--
Message posted via http://www.officekb.com