Try in D13:
Drag down and across.![]()
=IF(SUMIF(INDIRECT(D$9&"!$C$12:$C$44"),$B13,INDIRECT(D$9&"!$d$12:$d$44"))>0,SUMIF(INDIRECT(D$9&"!$C$12:$C$44"),$B13,INDIRECT(D$9&"!$d$12:$d$44")),"")
Try in D13:
Drag down and across.![]()
=IF(SUMIF(INDIRECT(D$9&"!$C$12:$C$44"),$B13,INDIRECT(D$9&"!$d$12:$d$44"))>0,SUMIF(INDIRECT(D$9&"!$C$12:$C$44"),$B13,INDIRECT(D$9&"!$d$12:$d$44")),"")
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks