Combining Sum, IF and AND

[Guest]

I have a Workbook that tracks reference numbers for different jobs. An
example is this.

Ref # Salesperson
180000 Dave
180010 Scott
180025 Dave
250234 Dave

I have two problems, I'd like to be able to count the number of reference
numbers that are greater than 180000, but less than 250000.

The other problem is I'd like to count how many times a salesperson used a
reference number within that same range, greater than 180000, but less than
250000.

So I'd like results like:

Reference Numbers Between 180000 and 250000: 3

Dave's Sales Between 18000 and 250000: 2

Thanks for your help

 

[Bob Phillips]

=SUMPRODUCT(--($A$2:$A$1000>=180000),--($A$2:$A$1000<=250000))

and

=SUMPRODUCT(--($A$2:$A$1000>=180000),--($A$2:$A$1000<=250000),--($B$2:$B$100
0="Dave"))

--

HTH

RP
(remove nothere from the email address if mailing direct)