# 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

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?

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

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1