View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spinnerron Spinnerron is offline
external usenet poster
 
Posts: 2
Default 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?