in sheet 1 if 4/8/18 total planned is 210 and 5/8/18 planned is also 210. and if i enter in cell i2 5/8/18, it should show up final result out of 420 and if i enter 6/8/18 it should show out of 630 and so on....
in sheet 1 if 4/8/18 total planned is 210 and 5/8/18 planned is also 210. and if i enter in cell i2 5/8/18, it should show up final result out of 420 and if i enter 6/8/18 it should show out of 630 and so on....
Hi
Try this in J3, K3, L3 and copy down
Formula:=SUMIFS(JOB,C$3:C$42,I3,B$3:B$42,"<="&$I$2)
Formula:=SUMIFS($E$3:$E$42,$C$3:$C$42,I3,$B$3:$B$42,"<="&$I$2)
Formula:=SUMIFS($F$3:$F$42,$C$3:$C$42,I3,$B$3:$B$42,"<="&$I$2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks