Help to eliminate a #VALUE error

[pedro-egoli]

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
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
6				KLMTravelled,fuelefficiencyandFuelCosts							CaravanParkdetails		Food	Grog	sundry		TotalDailyCosts
7	Day	Date	Fueldate	KLM's	Litres	Cost$	Klm/Ltr	Ltr/100Klm	Cost	Perdaycostexfuel	Cost$	NoNights	Cost$	Cost$	Cost$	Type
8	1	21/03/09	20/03/2009	771	127.53	$204.05	6.05	16.54	1.60	30.00	30.00	1					234.05
9	2		21/03/2009	254	38.40	$61.44	6.61	15.12	1.60								#VALUE!
10	3		25/03/2009	771	127.53	$204.05	6.05	16.54	1.60								#VALUE!
11	4	20-Mar-09								40.00			$40.00				#VALUE!
trip costs

Please ignore dates , they are just for testing purposes

Any help appreciated once again

Pedro

 

[Peter_SSs]

Try

=SUM(F8,J8)

 

[pedro-egoli]

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]

Would this work then?

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

 

[pedro-egoli]

Perfect Peter, works a treat.

Pedro