Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Quote:
=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)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Redirection After Cutting | Excel Discussion (Misc queries) | |||
Bar Cutting Optimization???? | Excel Programming | |||
cutting text | Excel Discussion (Misc queries) | |||
How to count process running time ( process not finished) | Excel Programming | |||
How to count process running time ( process not finished) | Excel Programming |