Date & amount

[Target]

Hello
I have two columns & about 1644 rows , first column is for date in this format (19-May-2002) and the second is amounts paid .
I want to know , e.g how many payments was there in each date below $2000 ?
Thank you, for your help in advance .

[Aladin Akyurek]

On 2002-05-20 00:00, Target wrote:
Hello
I have two columns & about 1644 rows , first column is for date in this format (19-May-2002) and the second is amounts paid .
I want to know , e.g how many payments was there in each date below $2000 ?
Thank you, for your help in advance .

Different approaches are possible.

Make a unique list of dates of interest in a separate column (with Advanced Filter, for example), say, in D from D2 on.

In E2 enter and copy down:

=SUMPRODUCT(($A$2:$A$1645=D2)*($B$2:$B$1645<2000))

where A2:A1645 houses the dates and B2:B1645 the paymants.


[ This Message was edited by: Aladin Akyurek on 2002-05-20 00:34 ]

[Target]

Thanx
Please explain more , How to filter the dates first ?

[Aladin Akyurek]

On 2002-05-20 01:19, Target wrote:
Thanx
Please explain more , How to filter the dates first ?

Lets say that, as I supposed in my post, the dates are in column A from A2 on. If there isn't a label in A1, type Dates there.
Make the label distinct by formatting it bold and italic.

Activate A2.
Activate Data|Filter|Advanced Filter.
Check Copy to another location.
Make sure that the range in the List range box is $A$2:$A$1645 (adjust to suit).
Leave the box for the Criteria range empty.
Enter $D$2 for Copy to.
Check Unique records only.
Activate OK.

Aladin


[ This Message was edited by: Aladin Akyurek on 2002-05-20 01:27 ]

[Target]

Aladin ,
I miss one thing , I need 2000 to be counted so more & equal 2000 .
thanx

[Aladin Akyurek]

On 2002-05-20 05:10, Target wrote:
Aladin ,
I miss one thing , I need 2000 to be counted so more & equal 2000 .
thanx

Just change the relational operator < to <=, tha is,

=SUMPRODUCT(($A$2:$A$1645=D2)*($B$2:$B$1645<=2000)