Cutting out a process

[FooFighter616]

Hi

So before I asked
question:http://www.excelbanter.com/showthread.php?t=445627, which ha
now been solved

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)". Th
cell B255 contains the formul
"=SUMIF(L$181:L$234,"<2400",$H$181:$H$234)".

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

Thank

 

[Claus Busch]

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

 

[Spencer101]

Hi,

So before I asked
question:http://www.excelbanter.com/showthread.php?t=445627, which ha
now been solved.

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)". Th
cell B255 contains the formul
"=SUMIF(L$181:L$234,"<2400",$H$181:$H$234)".

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

Thanks

You could try....

=IF(L181<2400,$M$180*H181/SUMIF(L$181:L$234,"<2400",$H$181:$H$234))

Although I'm not a fan of SUMIF, I prefer SUMPRODUCT as it's easier t
read when you have multiple conditions in the formula, so I would use

=IF(L181<2400,$M$180*H181/SUMPRODUCT(--(L$181:L$234<2400),$H$181:$H$234)