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?
|