| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting values from a range that equal a specific total | Excel Worksheet Functions | |||
| Count Specific word in specific range | Excel Worksheet Functions | |||
| Display values set in a range?? | Excel Worksheet Functions | |||
| Displaying numbers stored in a range??? | Excel Discussion (Misc queries) | |||
| How do I define a range using values in cells? | Excel Worksheet Functions | |||
Linear Mode
