Conditional summatioon – using SUMIF I think

Topic

New Reply

I am trying to create a total for orders placed on a specific day, so I have a named range called “Price” and another named range – “Date_ordered” and I want to create a total for orders placed on, e.g., June 13, 2011. so I create this formula:

=SUMIF(Date_ordered,”=”&DATE(2011,6,13),Price)

I may also want to create a total for orders placed on another date, e.g., June 30, 2011.

This does not give me the results I expected (obviously), rather it gives me a “date” as the result of the “SUMIF” operation. Can someone help me straighten this out? Thanks.

Ron_M

Reply | Quote

Replies

X2: 13-Jun-11

Y2:

=SUMIF(Date_ordered,X2,Price)

should yield a total rekated to X2.

If you enter 30-Jun-11 in X3, the formula can be copied down to obtain the total for X3.

Are we missing something?

Reply | Quote

I suspect it’s just cell formatting if you are getting a date – Excel stores dates as numbers. Change the cell format to a number format or General and see if the result tallies with what you expect.

Reply | Quote