| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct, multiple if, some same cell, determine number of rows
Here is what I am trying to do:
A B C 7000000 GL-2 $100 7126150 AR-PY $200 7135250 GL-2 $300 7137150 GL-2 $400 7139150 GL-2 $500 7145975 GL-2 $600 First...I need to check if numbers in A column are greater than 7000000 and less than 7140999. Next identify only numbers that end in 150. Next check column B and identify on the GL-2 cells...finally add the values in column C. So the answer here should be $900. =SUMPRODUCT((A5:A107000000)*(A5:A10<7140999)*(1*R IGHT(A5:A10,3)=150)*(B5:B10="GL-2"),C5:C10) The above works (thanks Ashish), BUT...I don't know how many rows for sure I need to scan down)...so A10, may be A945 or A466. How can I tell it how many rows? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count number of rows < Sumproduct | Excel Worksheet Functions | |||
| How to determine the cell contain number only? | Excel Discussion (Misc queries) | |||
| Determine number of rows meeting a condition | Excel Discussion (Misc queries) | |||
| How do I determine the number of cell formats in this workbook | Excel Discussion (Misc queries) | |||
| How to determine which rows contain slected cells in a multiple c. | Excel Worksheet Functions | |||
Threaded Mode
