And we appreciate you taking the time to let us know the result.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lovella via OfficeKB.com" <u15634@uwe wrote in message
news:5735525f30eb0@uwe...
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