Quote Originally Posted by VISHAL120 View Post
Msg 7: -SUMIF($AM$58:$AM65,$AM66,BE$58).
Normally this sumif is suppose to do the calculation based on the capacity set by dept from rows AV5:AV56. example.
It shall check if there is still capacity to load and by how much like order 1 has already taken 4000 mins therefore the balance available mins is…
This is what this sumif is suppose to do about. Well I don't know if am doing it right that is why i need some advise and recommendations. Am attaching a file to illustrate an example of that.
I hope this can help you to figure out what the calculation is doing.
OK, so it's just msg#7 that I'm not 100% sure about but I'm guessing that part is supposed to be (in cell BE66):
-SUMIF($AM$58:$AM65,$AM66,BE$58:BE65)

So unless I hear to the contrary I'll press on with that.