Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I find vaues of cells using 2 search criteria?
G'day,
I'm having trouble gettin my spreadsheet to find and add values based on 2 search criteria. I want the sreadsheet to find a date, and cross reference it with a person, and then return a value, or sum of values from a 3rd column. The problem lies in that there can be more than one match for these two criteria, ie, 2 dates with the same person. How can I get the formula to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refine search criteria for Find Method | Excel Programming | |||
Cells.Find , why it DOESN'T search ? help | Excel Programming | |||
Cells.Find , why it DOESN'T search ? help | New Users to Excel | |||
To find different values in Col B corresp. to repeated vaues in c | Excel Worksheet Functions | |||
multiple search criteria to find and copy from sheet1 and paste into sheet2 | Excel Programming |