SUMIF ACROSS MULIPLE TABS

[noel1]

Forum gurus..

I would like to have a summary sheet to calculate all the values in column 1 adjacent to ref 1 and do this across 10 tables.

I'm a construction estimator and this would be helpful if excel can do that.

So...each table may have up to 10 products made by various suppliers.

Then they may price up the same task across 10 buildings.

Then I would like to pull all these values from 10 sheets to 1 summary page with totals for supplier A, B, C D etc.

 

[Skybluekid]

Forum gurus..

I would like to have a summary sheet to calculate all the values in column 1 adjacent to ref 1 and do this across 10 tables.

I'm a construction estimator and this would be helpful if excel can do that.

So...each table may have up to 10 products made by various suppliers.

Then they may price up the same task across 10 buildings.

Then I would like to pull all these values from 10 sheets to 1 summary page with totals for supplier A, B, C D etc.

Are you able to post some data and expected results?

 

[noel1]

So the 1st image is the scenario of multiple sheets with names and values

2nd image is the sheet profile which is the same for all the sheets..

3rd sheet is the calc working on 1 sheet but i would like to add multiple sheets.

 

[Fluff]

How about

=LET(v,VSTACK(Sheet2:Sheet6!$A$1:$B$8),SUM(TAKE(FILTER(v,INDEX(v,,1)=A1),,-1)))

 

[noel1]

Omg...that is just freakin amazing..how did you know that...

I'm lol that you can work with logic like that...how cool.

My son is actually saying that is so clever...

Well done team excel

 

[Fluff]

You're welcome & thanks for the feedback.

 

[noel1]

You're welcome & thanks for the feedback.

Knowledge is key and little knowledge is dangerous...

If my values are not in column B but in column as sample...M and my supply chain will be listed in column P..How does alter the formula..

Do I select only the columns M8 (Values) to P last line number say 50..

What is the logic to change in the formula text pls Fluff.

 

[Fluff]

Does col P contain the criteria for the sumifs?

 

[noel1]

Something else that changes and that's the sheets between, so will select them by individual sometimes and not linear if that makes sense..

 

[noel1]

Yellow tabs as a sample