ExcelBanter - Cutting out a process

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Cutting out a process (https://www.excelbanter.com/excel-worksheet-functions/445644-cutting-out-process.html)

Cutting out a process

Hi,

So before I asked a question:http://www.excelbanter.com/showthread.php?t=445627, which has 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)". 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?

Thanks

Quote:

Originally Posted by FooFighter616 (Post 1600339)

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 to 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))