stuck with value error

[klsservices]

Hi
I have been going around in circles for a few weeks, not been doing much excel work for a few months and boy I got rusty quick!!

I am having problems with this formula:
=IF(COUNTBLANK(U53)=1,"",((U$3-T$3)*(U53+U65+U77)))
it works great when the spreadsheet is blank, but now that the data is entered, on some columns it is not working because U53 is not blank, but U65 and/or U77 is blank.
If 1 or 2 of the others are blank I still need the formula to work out a total and not give a value error...

I have got totally confused so Hope someone can help

thanks in advance

 

[Zakkaroo]

Your formula looks fine to me, I have tried it out and the only time I can get it to return a #VALUE! is if U3, T3, U53, U65 or U77 is a NON-NUMERICAL character.

Have you got an example set of data where you end up with #VALUE! ?

i.e Tell us what is in each of these cells when you are getting an error

U3 =
T3 =
U53 =
U65 =
U 77 =

 

[baodinh]

Use SUM(U53,U65,U77) instead of (U53+U65+U77).

 

[klsservices]

Use SUM(U53,U65,U77) instead of (U53+U65+U77).

DOH!I knew it would be something simple!!
that fixed it...
the cells contain formulas that add up feed rations and stock numbers,

BIG THANKS I can now stop tearing my hair out and got drink that glass of wine which is sat waiting