Summing Accross multiple worksheets

this should do the trick..

=SUM(Sheet1:Sheet4!A2:C4)

Originally Posted by NBVC

=Sumif('Sheet1'!A:A,">="&A1,'Sheet1'!B:B)-Sumif('Sheet1'!A:A,">"&B1,'Sheet1'!B:B)

this formula sums column B for dates in A that are defined by start/end dates in A & B1, respectively.

Do the same for all 3 sheets and add together.

Or you can do your sumif in a specific cell of each sheet.... and then just Sum the cell on each sheet... e.g. =Sum('Sheet1:Sheet3'!X1) where X1 contains sum on each sheet.

I tried to follow this; however, it did not work. The above formula is only giving me one condition so the amount is not being returned. What I need is if I assign a date then it will pull all the amounts for that date within the three worksheets and sum the amount.

Originally Posted by NBVC

And you tried day92's answer?

If so, and not what you want, post an actual sample workbook showing what you need.

Okay here is the sample. I appreciate all of your help.

Originally Posted by NBVC

As long as every cell is one to one... so sheet4 would be exact same setup of sheets1 to 3, then in B3 enter:

=SUM(Sheet1:Sheet3!B3)

copy it down and across the matrix.

Its not the same. What if in worksheet 1,2,3 you have more than one line item with the same date? You can't just sum accross with the above formula. Sheet 4 is not going to be exactly like sheet's 1 thru 3.