Formula Question - Sum Between 61 - 90

  • Thread starter Thread starter Brig Siton
  • Start date Start date
B

Brig Siton

We are creating an aging report from excel.

Criterias are (days):

1. 0 - 30
2. 31 - 60
3. 61 - 90
4. 90 +

We have a list of items with dates ranging from 2002 to present

What we are trying to do is calculate how much money per criteria.

I am able to calculate the 0 - 30 and 90 +. However, I need your help
regarding how to calculate the items for criteria 2 and 3.

Any help is greatly appreciated.

Thank you.

Brig Siton
 
Is it a table ??

If it is then try this

0 - 30 =SUMPRODUCT(--($A$2:$A$5<=30)*($B$2:$B$5))
31 - 60 =SUMPRODUCT(--($A$2:$A$5>30)*($A$2:$A$5<=60)*($B$2:$B$5))
61 - 90 =SUMPRODUCT(--($A$2:$A$5>60)*($A$2:$A$5<=90)*($B$2:$B$5))
90 + =SUMPRODUCT(--($A$2:$A$5>90)*($B$2:$B$5))

Assuming A column has Days and B column has Money

Vba Noo
 
Whatever you use for calculating 0-30, do the same for 0-60 with a slightly
amended criteria, and subtract the 0-30 result from it. And so on.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Back
Top