| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining sumIF statements with other functions?
I am wondering can a 'sumif statement and vlookup formula' be combined to
provide a total of a range of numbers or maybe even combined with using 'greater than a number but less than another number' functions. For example, I have a range of 5 digit numbers in column 'A', and have dollar amounts that correspond to those 5 digit numbers in column 'B', in a seperate tab I need a formula that would look in coulmn 'A' for a range of numbers (for ex.. greater than 10000 and less than 19999) then give me the total of the corresponding dollar amounts in column 'B'. Is this possible or am I SOL???? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining 2 IF statements | Excel Discussion (Misc queries) | |||
| Combining subtotal and sumif functions | Excel Worksheet Functions | |||
| Combining IF statements | Excel Worksheet Functions | |||
| Combining SUMIF and SUBTOTAL functions | Excel Worksheet Functions | |||
| Combining IF and multiple SUMIF statements, if A>0 & B is between | Excel Worksheet Functions | |||
Threaded Mode
