# How to overcome #VALUE!

#### ahamed

##### Board Regular
Hi !!!

I have issue with sum function. I want to sum up a range of cells which contains formula of ""

(ex- =IF(ISERROR(IF(\$R14="","",((\$Q14*\$R14)))),"",(IF(\$R14="","",((\$Q14*\$R14)))))

When there is empty cells (due to use of "" function) I get an error message (#VALUE!) when I total those cells.

Thanks

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
You are multiplying, not totaling...

=N(\$Q14)*N(\$R14)

will return either a 0 or a non-zero numeric result.

BTW, totaling would run like...

=SUM(\$Q14,\$R14)

Hi

I think you all got wrong.

I want to sum up (or total) particular cells. When I total it I get #VALUE. The reason why I get error message is few cells of those cells I summed is just a blank.

In normal scenario we do not get error when we sum blank cell. Here the blank cells contains of formulas with ""

for example the cell may become blank since the following formula is used- =IF(ISERROR(IF(X14>0,W14*X14,"")),"",(IF(X14>0,W14*X14,"")))

As I mentioned above since few blank cells contains of these formulas (mentioned above) I cant add up (or total ) those cells. If I do I get #VALUE!.

Pls help me

Last edited:
Hi

I think you all got wrong.

I want to sum up (or total) particular cells. When I total it I get #VALUE. The reason why I get error message is few cells of those cells I summed is just a blank.

In normal scenario we do not get error when we sum blank cell. Here the blank cells contains of formulas with ""

for example the cell may become blank since the following formula is used- =IF(ISERROR(IF(X14>0,W14*X14,"")),"",(IF(X14>0,W14*X14,"")))

As I mentioned above since few blank cells contains of these formulas (mentioned above) I cant add up (or total ) those cells. If I do I get #VALUE!.

Pls help me

Why don't you try the suggestion?

Thanks I did not get it at all..
now seems oki

Replies
0
Views
360
Replies
3
Views
119
Replies
1
Views
699
Replies
7
Views
137
Replies
1
Views
307

1,219,811
Messages
6,150,366
Members
450,955
Latest member
rose8693

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back