| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I find vaues of cells using 2 search criteria?
List of dates in A2:A20. Date to find in G1:
List of Names in B2:B20. Name to find in F1 Values to sum in C2:C20 =SUMPRODUCT(--($A$2:$A$20=$G$1),--($B$2:$B$20=$F$1),$C$2:$C$20) Hope this helps Rowan Spinnerron wrote: 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I find vaues of cells using 2 search criteria?
You're a legend mate. Thankyou
"Rowan Drummond" wrote: List of dates in A2:A20. Date to find in G1: List of Names in B2:B20. Name to find in F1 Values to sum in C2:C20 =SUMPRODUCT(--($A$2:$A$20=$G$1),--($B$2:$B$20=$F$1),$C$2:$C$20) Hope this helps Rowan Spinnerron wrote: 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How can I find vaues of cells using 2 search criteria?
No worries!
Spinnerron wrote: You're a legend mate. Thankyou "Rowan Drummond" wrote: List of dates in A2:A20. Date to find in G1: List of Names in B2:B20. Name to find in F1 Values to sum in C2:C20 =SUMPRODUCT(--($A$2:$A$20=$G$1),--($B$2:$B$20=$F$1),$C$2:$C$20) Hope this helps Rowan Spinnerron wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
