Hi,

Am Mon, 2 Apr 2012 09:37:01 +0000 schrieb FooFighter616:

Continuing on from this however, I now need to cut out a process.
Currently I have this formula "=IF(L181<2400,$M$180*H181/$B$255,0)". The
cell B255 contains the formula
"=SUMIF(L$181:L$234,"<2400",$H$181:$H$234)".

Basically, I want to cut out the cell B255 and have the whole thing in
one formula. Is this possible and how would I do this?

you have to replace $B$255 in the first formula with the formula into
B255:
=IF(L181<2400,$M$180*H181/SUMIF(L$181:L$234,"<2400",$H$181:$H$234),0)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2