Sum Question

J

JE McGimpsey

First, your SUM() function is redundant. It returns the same result as

=B5*H5

One way to show a null string instead of zero:

=IF(AND(B5<>"",H5<>""),B5*H5,"")
 
J

John Kitchens

I am using Excel 2000
I have the following very simple formula in column j Sheet1

=SUM(B5*H5)
I have this copied all the way down to line 40.

It shows 0 in all of the cells all the way down. I would like for there to
be a way that the cell would not show anything in it UNLESS there was
something that it was calculating.

For example. I have entered data in column b and column h
through line 10, but it still shows 0 in column J all the way down to line
40.

I realize that it is showing these 0's b/c I have placed the formula there,
but is there a way that it will still calculate but only if there is data in
column b and h?

I hope this makes sense.

Thanks for any help.

Sincerely,

John Kitchens
 
J

John Kitchens

JE,

That did it! Thank you so much for your quick response.
Maybe you can help me with somthing else. I posted yesterday under the
Subject line of "Another Macro Problem"

As of yet I have not gotten a response from that post.

Once again thank you.
Sincerely,
John Kitchens
 
D

Dave Peterson

You have one guess at yesterday's thread.

John said:
JE,

That did it! Thank you so much for your quick response.
Maybe you can help me with somthing else. I posted yesterday under the
Subject line of "Another Macro Problem"

As of yet I have not gotten a response from that post.

Once again thank you.
Sincerely,
John Kitchens
Click to expand...
 
Top