adding numbers in a specific range of values
 

I have column A listing miles from point to point, column B give the number
of occurences in 60 days. I'm trying to add up the number occurences if the
miles are in between lets say 50 and 150 miles. Can anyone help?

adding numbers in a specific range of values
 

=SUMPRODUCT(--(A1:A100=50),--(A1:A100<=150),B1:B100)
You can not use whole column A:A or B:B

"Tophaw" wrote:

I have column A listing miles from point to point, column B give the number
of occurences in 60 days. I'm trying to add up the number occurences if the
miles are in between lets say 50 and 150 miles. Can anyone help?

adding numbers in a specific range of values
 

=COUNTIF(A:A,"=50")-COUNTIF(A:A,"150")

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Tophaw" wrote in message
...
I have column A listing miles from point to point, column B give the
number
of occurences in 60 days. I'm trying to add up the number occurences if
the
miles are in between lets say 50 and 150 miles. Can anyone help?