Hi All,
Pls see attached relevent file.
i'm not sure why i'm not getting the values for "2" item in the summary table.
I'll appriciate your help,
Thanks
Hi All,
Pls see attached relevent file.
i'm not sure why i'm not getting the values for "2" item in the summary table.
I'll appriciate your help,
Thanks
Try
C45=IFERROR(IFERROR(INDEX($C$23:$F$39,MATCH($B45,$B$23:$B$39,0),MATCH(C$43,$C$22:$F$22,0)),0)+IFERROR(INDEX($C$2:$F$19,MATCH($B45,$B$2:$B$19,0),MATCH(C$43,$C$1:$F$1,0)),0),"-") and drag towards the cell
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Or
=SUMIF($B$2:$B$39,$B45,F$2:F$39)
Assuming row labels are present in summary.
Last edited by JohnTopley; 06-01-2016 at 03:20 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks