Formula Question - Sum Between 61 - 90

[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

 

[VBA Noob]

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

 

[Bob Phillips]

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)