simple SUM Formula

[John Caines]

hello All.

I'm trying to write a simple formula (Which works and has given me the correct result), but I'm not sure the formula is written correctly,, IE it could be a more 'PURE',, condensed form?

My formula is;

=IF(O28="","",SUM($O$24:$O$28)-SUM($L$24:$L$28))

Is there another way to write the above? Or is this fine?
Just looking at it with 2 SUMs in,,, just doesn't seem correct to me?
Maybe it is,,,,

If anybody could just confirm for me please, or show me if there is indeed a better way to write the above.

Many thanks

John Caines

 

[justme1122]

looks fine to me

 

[NBVC]

Unless you have cells containing those sums that you can use instead to reduce the calculations necessary, I think that is okay.

 

[JackDanIce]

Looks fine to me, one change you could make is your test condition, i.e.

=IF(LEN(O28)=0,"",SUM($O$24:$O$28)-SUM($L$24:$L$28)

Otherwise, your formula appears to be as reduced/efficient as it can be...

 

[John Caines]

Many thanks for all your rapid replies,, many thanks.

Great!! Seems fine then,,,

JackDanIce,, Regarding your LEN part in a formula,,, I've never come across that 1 before,, just googled it,,,, hard to understand from what I was reading as my excel VB is poor to be honest,,
http://msdn.microsoft.com/en-us/library/dxsw58z6(v=vs.80).aspx

But,,, seems to do the same as I had,, but maybe in a more 'Pure' way? (Where I'm getting this pure from I don't know ,,,,

I think I'll migrate over to this 'LEN' part of the formula,, hell, why not,,,

Many thanks again for all your replies.

Best Regards
John Caines