Put below formula in C7 & drag :
Formula:
=IFERROR(SUMIFS(INDIRECT(C$6&"!G:G"),INDIRECT(C$6&"!A:A"),$B7),0)
Cheers!
Put below formula in C7 & drag :
Formula:
=IFERROR(SUMIFS(INDIRECT(C$6&"!G:G"),INDIRECT(C$6&"!A:A"),$B7),0)
Cheers!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks