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...
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.
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.
If you can upload the actual workbook, it would be more helpful than a screenshot.