# Help to eliminate a #VALUE error

#### pedro-egoli

##### Well-known Member
Just going round in circles at the moment trying to sum two cells with an isblank formula.

Spreadsheet is for costing a trip and to save duplication, a link has been established to automatically record details entered in another sheet within the same workbook (columns C to I ).
You will note I want to record a total for cells in columns F and J, and the way I have gone about it is creating the problem.
It will work if i enter details for both fuel (column F) AND per day ex fuel (column J) but there will be occasions when I will only enter details for only one of these columns.

The spreadsheet below shows the problem
Budget.xls
ABCDEFGHIJKLMNOPQ
6KLMTravelled,fuelefficiencyandFuelCostsCaravanParkdetailsFoodGrogsundryTotalDailyCosts
7DayDateFueldateKLM'sLitresCost\$Klm/LtrLtr/100KlmCostPerdaycostexfuelCost\$NoNightsCost\$Cost\$Cost\$Type
8121/03/0920/03/2009771127.53\$204.056.0516.541.6030.0030.001234.05
9221/03/200925438.40\$61.446.6115.121.60 #VALUE!
10325/03/2009771127.53\$204.056.0516.541.60 #VALUE!
11420-Mar-09       40.00\$40.00#VALUE!
trip costs

Please ignore dates , they are just for testing purposes

Any help appreciated once again

Pedro

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Try

=SUM(F8,J8)

#### pedro-egoli

##### Well-known Member
Thanks Peter, That works fine.

However, I forgot to mention I was trying to elimine "0" where there is no data in columns existed.
That is how I came up with the isblank formula.

Any suggestions.

Pedro

#### Peter_SSs

##### MrExcel MVP, Moderator
Would this work then?

=IF(F8&J8="","",SUM(F8,J8))

#### pedro-egoli

##### Well-known Member
Perfect Peter, works a treat.

Pedro

Replies
8
Views
204
Replies
0
Views
176
Replies
0
Views
193
Replies
4
Views
2K
Replies
3
Views
147

1,190,587
Messages
5,981,805
Members
439,735
Latest member
Cbegg

### 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