| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
finding data between two numbers (1000-1999)and totaling correspo.
I have a list of four digit numbers. I need to search the list and any that
start with 10.. I have to total the numbers from a corresponding column of all that match this criteria and display it. |
|
#2
|
|||
|
|||
|
one way:
With 4 digit numbers in A1:A1000, and corresponding column B: =SUMPRODUCT(--(INT(A1:A1000/100)=10),B1:B1000) In article , plasticmaker wrote: I have a list of four digit numbers. I need to search the list and any that start with 10.. I have to total the numbers from a corresponding column of all that match this criteria and display it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Linear Mode
