SumIF with Dates

[JOGIER]

In the expense log, Column C is a list of Dates and Column I is a list of expenses. I want to Sum the expenses in the 'Expense Log 09' to a new sheet based on a Date entered in H24 on the new sheet. I have tried the formula as shown below and Get the result #NAME?

=SUM(IF(Expense Log 'Expenses Log 09'!C8:C100,H24,'Expenses Log 09'!I8:I100))

I would Like to SUM all expenses After the posted date including that date.

Thanx

Jim O

[DonkeyOte]

Perhaps you mean:

=SUMIF('Expenses Log'!$C$8:$C$100,">="&H24,'Expenses Log'!$I$8:$I$100)

[JOGIER]

Yea, that's the ticket! Thanx.

One further question if I may. using the same data set how would I retrive a SUM from a given period of time, say a week or a few days?

[JBeaucaire]

Two ways to try, Don's original SUMIF and then another to subtract the dates after a second cell value, like I24:

=SUMIF('Expenses Log'!$C$8:$C$100,">="&H24,'Expenses Log'!$I$8:$I$100)-SUMIF('Expenses Log'!$C$8:$C$100,">"&I24,'Expenses Log'!$I$8:$I$100)

The second would be a SUMPRODUCT formula:

=SUMPRODUCT(--('Expenses Log'!$C$8:$C$100>=H24),--('Expenses Log'!$C$8:$C$100<I24),Expenses Log'!$I$8:$I$100)

[DonkeyOte]

There are a few options, the simplest is to conduct 2 SUMIFS... let's assume as before H24 has the "From" date and I24 has the "To" date then to get the Sum of values in between those dates:

Please Login or Register  to view this content.

The above sums value >= H24 and subtracts values that exceed I24.

The other common approach is to use a Sumproduct though this is arguably more "expensive" than the SUMIF approach.

EDIT: apologies JB, simultaneous posts strike again...

[JOGIER]

Thank you both for your time and knowledge.

Jim O