sumif values older than dec 13

[kghisla]

Dear friends,

I need a formula summing the value (column F) only for items bought after JANUARY 2013 (column C).
(POST TITLE say DEC 13, but it's january 2013, even though concept doesnt' change)
Please see file attached: stock date

I am not sure the date format is right.

Any help in resolving this issue would be greatly appreciated.

Carlo

ps. I am using excel for mac 14.3.9 version 2011

[Tony Valko]

I didn't download your file.

Maybe something like this...

=SUMIF(C:C,">="&DATE(2013,1,1),F:F)

Or, use a cell to hold the date criteria:

A1 = 1/1/2013

=SUMIF(C:C,">="&A1,F:F)

[Ace_XL]

Try this array formula

=SUMPRODUCT((IFERROR(DATE(RIGHT(C4:C594,2),LEFT(C4:C594,2),1),0)>DATE(13,1,31))*(F4:F594))

Confirm with Ctrl+Shift+Enter not just Enter

[kghisla]

Hi Tony,
thank you very much for your help, but it didn't work, neither one of the two suggestions.
is it for date format?
regards,
Carlo

ps please see new file attached

[kghisla]

Hi Ace,
thank you very much for your suggestion!
it seems to work even though i have no idea how you did it, but thank you so much.
In your opinion, is there another easier way, maybe should I change every date value in a different format (like 1/12/13) in column C in order to make it work like Tony said?
Regards,
Carlo

ps. please see new file attached.