Formula Question - Sum Between 61

Formula Question - Sum Between 61 - 90

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brig Siton - 12 Jul 2006 22:06 GMT

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

Reply to this Message

VBA Noob - 12 Jul 2006 22:31 GMT

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

Reply to this Message

Bob Phillips - 12 Jul 2006 23:51 GMT

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.

Signature

HTH

Bob Phillips

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

> We are creating an aging report from excel.
>
[quoted text clipped - 17 lines]
>
> Brig Siton

Reply to this Message

Brig Siton - 13 Jul 2006 13:53 GMT

Thank you very much for all your help.

That worked.

> Whatever you use for calculating 0-30, do the same for 0-60 with a
> slightly
[quoted text clipped - 21 lines]
>>
>> Brig Siton

Reply to this Message