Forum

Notifications
Clear all

Sumif & Vlookup

2 Posts
2 Users
0 Reactions
59 Views
(@joseguambe)
Posts: 1
New Member
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
(@sunnykow)
Posts: 1417
Noble Member
 

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
Share: