Forum Discussion
Date range based Sum Up from multiple work sheet
Hi, I have a work book with 26 sheets., where Jumbo1 is sheet one and Boeing9 is sheet 26. All 26 sheets are with identical column and data. I want a formula, to add up amounts collected, for a mo...
Create a list of the sheet names Jumbo1 ... Boeing9 in a column on the same sheet as the formula, say in N1:N26. You can then use
=SUMPRODUCT(SUMIFS(INDIRECT("'"&N1:N26&"'!D3:D34"),INDIRECT("'"&N1:N26&"'!C3:C34"),">"&H11))
- Thanks Hans, I will try. Someone on FB gave me that idea, but it giving me false total. This was the formula =SUM(SUMIFS(INDIRECT(A1:A26&"!D3:D34"),INDIRECT(A1:A26&"!C3:C34"),">"&H11))
I don't know how to upload a pic here, otherwise it was easy with ascreen shot.- Did you sumif each sheet individually and compare to your manual calculation for each sheet to identify which worksheet(s) were causing the variance? It may be an issue with the data or your manual calculation is off.
If you can upload the actual workbook, it would be more helpful than a screenshot. Save your screenshot to disk, then drag the picture file from File Explorer / Finder into the reply box here.
HansVogelaar This is my practice sheet. So the sheet names are different, but the same in effect.
