Sum all negative/positive amounts if maturity date is less/more than twelve months

[Hans-Maulwurf]

Hi all,

could someone may help.

I need to sum up amounts in an excel sheet which are positive and long term(maturity more than 12 months)

This one is not giving a value.

=+IF(DATEDIF('M2M'!$A$1,'TX Ledger'!$G:$G,"y")>=1,SUM('TX Ledger'!J:J>0))

Could someone please help?

Thanks

[dosydos]

Could you please provide an example worksheet with your data desensitized for us to use?

[63falcondude]

Hello and welcome to the forum.

Assuming that today's date is in cell A1 of the 'M2M' worksheet, your dates are in column G of the 'TX Ledger' worksheet and that the amounts are in column J of the 'TX Ledger' worksheet, try this:

=SUMIFS('TX Ledger'!J:J,'TX Ledger'!J:J,">0",'TX Ledger'!G:G,">"&EDATE(M2M!A1,12))

[63falcondude]

You marked this as SOLVED so I am guessing that the formula from post #3 solved your problem.

You're welcome.