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.

 

[Fluff]

To sum col M based on P use

=LET(v,VSTACK(Sheet2:Sheet6!$M$1:$P$100),SUM(TAKE(FILTER(v,take(v,,-1)=A1),,1)))

 

[noel1]

Correct Fluff

 

[noel1]

So I'm setting up the collection sheet on what I call collection sheet. The data is listed on wall finishes and ceiling finishes..so that is the sheet I need to collect the info from.

Can I send you the excel file to capture on or shall we do teams if you like

 

[noel1]

I'm trying boss ..honestly...

 

[noel1]

Do you have a email to send the excel sheet on if that makes it easier...

 

[noel1]

Fluff...

I did it mate...I don't think it like my brackets in my tab name previous...I removed the brackets and it worked.

 

[Fluff]

Glad you sorted it & thanks for the feedback.

 

[noel1]

Sorry...speak to soon..just checked the values on 3.1 and 3.3 for Curo as a test...total is around £38k and £4k...sum around £42k..

But it only picked up values on sheet 3.3...

 

[Fluff]

Check for typos & leading/trailing spaces in the criteria.

 

[noel1]

Cracked it bud..

I had CURO BUDGET as ref link on 3.1 and on 3.3 I had CURO ONLY...

Your formula still work mate...well done..

Can you explan what the formula does and what the -1 represent and 1 in the formula pls..pls the other stuff as well guru