You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"The Hun" wrote in message
...
Thanks. Everything works now.



On Jun 13, 9:59 am, "T. Valko" wrote:
Just use a SUM formula:

=SUM(A3:A5)

SUM ignores text.

If there are no numbers then the result will be 0. If you don't want to
see
a 0 when no numbers are present then just use the same technique we've
shown
you in the other formulas to return a blank instead of a 0.

--
Biff
Microsoft Excel MVP

"The Hun" wrote in message

...

On Jun 12, 10:50 pm, "T. Valko" wrote:
It depends on what result you want when A1 is a text entry.

Start with this and we'll tweak it if needed:

=IF(COUNT(A1),A1*A2,"")

If A1 doesn't contain a number (that also means if A1 is empty) the
formula
returns a blank.

--
Biff
Microsoft Excel MVP

"The Hun" wrote in message

Thank you. All three of you gave me workable solutions. The answer
to the question each of you asked -- "what result do you want?" -- is
either blank or 0 (zero), and I was able to produce both results from
the answers you gave.

NEW Question: What if I include A4 and A5?

If A4 or A5 is text (such as "no chrg"), what statement in A6 will add
the numbers that remain in A3, A4 or A5 and give me a numerical value
in A6?

A1 = a number or text
A2 = a number
A3 = A1*A2
A4 = a number or text
A5 = a number or text
A6 = TOTAL A3+A4+A5 (and get a numerical value)

Do I have to write nested IF statements in A4 and A5? If I do, I'm
not entirely sure how to do it.

Thanks,