| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Suming selected cells based on two criteria
I am wishing to search two specific columns (text) in a data base for two
separate specific criteria (text)and if these are a match then I want to sum the numbers in a third colum that match the two criteria. It would be like a dual VLOOKUP with a SUMIF attached based on the basis of the results of a TRUE outcome of the VLOOKUP. Does anyone know if it is possible to search on two criteria and if a match sum all items in a third column, that have a match in regards to the two search criteria. You will be my idol if you are able to solve this one. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
| how do i add in numbers automatically based on adjacent cells cont | Excel Discussion (Misc queries) | |||
| sum number of cells based on letter/title criteria | Excel Worksheet Functions | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Threaded Mode
