Looking for non-array formula formula to pull values in sheet named Product into C5:F16 of Outcome sheet if conditions in B2:E2 are met. Sample file attached.
Conditions:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by bjnockle; 09-10-2017 at 07:24 PM.
Try placing the following formula in cell C5, drag-copying it down and across as needed, and custom-formatting the cells as 0%;-0%;-
=IF(OR(--("1-"&$B5)<--("1-"&$C$2),--("1-"&$B5)>--("1-"&$D$2)),"",SUMPRODUCT((Product!$A$2:$A$33=$E$2)*(Product!$B$2:$B$33=$B$2)*(Product!$C$2:$C$33=C$4)*(Product!$D$1:$O$1=$B5),Product!$D$2:$O$33))
Last edited by Root_; 09-10-2017 at 08:53 PM.
Formula:
Please Login or Register to view this content.
Last edited by humdingaling; 09-10-2017 at 08:41 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks