Notifications
Clear all
Topic starter
Hi everyone
I attached a sample workbook with many sheets, with I need to summarize in a sheet "Global", I was trying use sumif with lookup, but I was straggled.
Can you help please!!!
Posted : 31/01/2018 3:37 am
Hi Jose
Welcome to the forum.
In sheet Global cell B2 enter =SUMIF(INDIRECT(B$1&"!A:A"),$A2&"*",INDIRECT(B$1&"!B:B"))
Copy down and left to suit your needs.
Hope this helps
Sunny
Posted : 31/01/2018 4:05 am