worksheet or Tab name : Summary
Cell C2 formula , Drag down and across
Formula:
=SUM(SUMIF(INDIRECT("FName"&ROW($1:$5)&"!A:A"),$A2,INDIRECT("FName"&ROW($1:$5)&"!R1C",)))
worksheet or Tab name : Summary
Cell C2 formula , Drag down and across
Formula:
=SUM(SUMIF(INDIRECT("FName"&ROW($1:$5)&"!A:A"),$A2,INDIRECT("FName"&ROW($1:$5)&"!R1C",)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks