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

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

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))

Thanks  Register To Reply

2. ## Re: Sum all negative/positive amounts if maturity date is less/more than twelve months

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

3. ## Re: Sum all negative/positive amounts if maturity date is less/more than twelve months

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))  Register To Reply

4. ## Re: Sum all negative/positive amounts if maturity date is less/more than twelve months

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

You're welcome.  Register To Reply