sumif from multiple tabs

[erenkey]

I have a spreadsheet that Sheet1 is being used as a monthly totals sheet. There is a seperate tab for each day of the month. Column A in sheet one contains Store Ids. I am looking for a formula the will help me find a monthly running total for each store. Each day that I get my information may be sorted differently. I am looking for a fomula so that I don't have to resort the information everyday.

Can anyone help? let me know if I need to explain it better.

 

[texasalynn]

So on the other sheets where is the store ID and what column is to be totaled?

 

[erenkey]

There are actually a bunch of columns that I need totaled but we can start with column C. I can adjust the formulas for the other columns.

 

[Haseeb Avarakkan]

Hello,

What is the tab name of each day? Is this like day #?

1,2,3,4.......28.29,30,31 ?

 

[erenkey]

yes each tab is named like the dates of the month 1,2,3,4,5,6,7,8,9,10.... The summary tab is called Month.

 

[Dave Patton]

Is it necessary to have a sheet for each day?
Can you install/use a free Add-in?

You can try

ShtList is a named range that includes all the relevant sheet names.
The criteria on the summary sheet is in A2
Range with amounts is H2:H100


=SUMPRODUCT(SUMIF(INDIRECT("'"&ShtList&"'!A2:A100"),A2,INDIRECT("'"&ShtList&"'!H2:H100")))

 

[erenkey]

Thanks Dave taht is what I was looking for.

 

[texasalynn]

...

 

[erenkey]

is there a way to change this formula to look at two sets of criteria instead of only one?

 

[Dave Patton]

Yes, a formula could use 2 criteria

You did not answer the questions or provide a relevant example.

Depending on the scope of the challenge, I would use

1. THREED from Mr. Longre's add-in Morefunc
2. Concatenate the criteria and use the formula cited
3. Use a complex formula, there are examples in this forum

hth Dave