Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Combining Sum, IF and AND
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 |
#2
|
|||
|
|||
=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) "Kenton_SJ" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|