Sum Question

  • Thread starter Thread starter JE McGimpsey
  • Start date Start date
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,"")
 
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
 
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
 
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...
 
Back
Top