With the below example data in 2 sheets named sheet1 and sheet2 ; try the
below formula..

=SUMPRODUCT(SUMIF(INDIRECT("'"& {"sheet1","sheet2"}
&"'!A:A"),C1,INDIRECT("'"& {"sheet1","sheet2"} &"'!B:B")))

You can used a named range of sheet names instead of the array {}. Try this
with dummy data and then change to suit your requirement


If this post helps click Yes
---------------
Jacob Skaria


"sunsetsweete" wrote:

I get how that works, but the sums that I am trying to add are from multiple
pages. How do I sum from more than one page?

Thanks!

"Jacob Skaria" wrote:

Try SUMF()

The below formula in D1 sum the values in ColB if the date in ColA is same
as the date mentioned in C1

ColA colB ColC ColD
7/17/2009 2 7/19/2009 =SUMIF(A:A,C1,B:B)
7/18/2009 3
7/19/2009 5
7/20/2009 1
7/21/2009 10
7/22/2009 15

If this post helps click Yes
---------------
Jacob Skaria


"sunsetsweete" wrote:

Hi!

I am trying to make a formula where I add up dollar amounts based on which
rows have a certain date.

I have a spreadsheet where I keep track of my sales for the day and I want
to add up my total sales in different categories for each day. Each
transaction is in a row and is dated. I have the workbooks split up into
type of sale instead of date so I need to find a way to have excel choose the
amounts based on the date given in another cell in the row.

Anyone know how to do this?

Thanks in advance!