Thread: adding numbers in a specific range of values
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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?
Reply With QuoteReply With Quote