Excel sum problem - need help

  • Thread starter Thread starter ranger373v
  • Start date Start date
R

ranger373v

I need to create a formula that ignores blank cells or error cells(#VALUE!).
My current formula is:

=SUM(I24*L24)+(J24*M24*K24) - Result is placed in N24. I then have the
result from N24 copied into cell G24 for printing on a quotation.

Which returns the correct sum if a number exists in all cells. However if
cell I24 is blank I want the result in G24 to also be blank.

I tried using conditional formatting to make the number white (backround is
white) if there is an error, but, that did not work either.

Any help appreciated.
 
Conditional formatting will also work witht his, but you need to make sure
the cell format is based on "Formula Is" rather than "Cell Value Is" in the
Conditional Formatting form, then the formula would be =IsError(cellref)
 
Thanks to all who responded. It will work. But, to add insult I also need to
add to the formula if the result is zero the result in G24 will also be blank.


Don said:
if(i24="","",yourformula)
I need to create a formula that ignores blank cells or error
cells(#VALUE!).
Click to expand...
[quoted text clipped - 11 lines]
Any help appreciated.
Click to expand...
Click to expand...
 
then you should have said so

--
Don Guillett
SalesAid Software
(e-mail address removed)
ranger373v said:
Thanks to all who responded. It will work. But, to add insult I also need
to
add to the formula if the result is zero the result in G24 will also be
blank.


Don said:
if(i24="","",yourformula)
I need to create a formula that ignores blank cells or error
cells(#VALUE!).
Click to expand...
[quoted text clipped - 11 lines]
Any help appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top