SUMIFS vs SUMIF - 2 Criterias needed

[jhsiao]

Dear Forum,

I have 2 sheets of data in the same workbook.

a) My first sheet, Table1 (Which I will be using to present data) is as follows:
LocationID Last 2 Month's Payment Last 12 Month's Payment
LONCLEVER
OSAACE123
SYDSPEEDY
NYCXYZ000
LONCLEVER
NYCXYZ000

b) My second sheet, Table2 (With the data that needs to be calculated) is as follows:
LocationID Receipt Date Receipt Amount
LONCLEVER 8/1/2013 6,474
OSAACE123 8/9/2013 100,569
SYDSPEEDY 4/5/2013 27,300
NYCXYZ000 4/5/2013 39,000
LONCLEVER 9/1/2013 70,000
NYCXYZ000 4/5/2013 500,000

Essentially - I am trying to find out:
1) Last 2 Month's Payment
2) Last 12 Month's Payment
Based on days from today's date and LocationID.

My pathetic attempt was:
=SUMIF(Table2[#ALL], TODAY()-Table2[@[Receipt Date]]>=60, Table2[@[Receipt Amount]]) and
=SUMIF(Table2[#ALL], TODAY()-Table2[@[Receipt Date]]>=60, Table2[@[Receipt Amount]])
I keep on getting zero...

Could someone please kindly point me to the right way here? Very much appreciated!
Many thanks in advance.

Kind Regards,

[humdingaling]

you should really include sample so people dont have to create usable data

also your formula continues tables/named ranges which i cant replicate

anyway see attached spreadsheet for your answer on sumifs


ps sumifs and sumif have different syntax

[FDibbins]

Thank you for the title change

[jhsiao]

Dear humdingaling

Thank you so much for the example. It is precisely what I had wanted.
Well noted about uploading examples and will do so in the future.

Again, many thanks for your time and help! So apprecaited!

Kind Regards,

[jhsiao]

Dear FDibbins

Thank you for the post.
My apologies for any earlier ambiguity. I have ammended accordingly.

Kind Regards,