| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching two values
Not quite sure how to write the formula to return value for D1 in new
worksheet. I need to match the values for both B1 and C1. B C D 1 ABC Insurance $100 2 ABC Taxes $200 3 DEF Insurance $150 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching two values
=SUMPRODUCT((Sheet1!B1:B3="ABC")*(Sheet1!C1:C3="In surance")*Sheet1!D1:D3)
You can substitute the "text" for a cell that the criteria is entered into. "Anna Wood" wrote in message ... Not quite sure how to write the formula to return value for D1 in new worksheet. I need to match the values for both B1 and C1. B C D 1 ABC Insurance $100 2 ABC Taxes $200 3 DEF Insurance $150 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching two values
That did the trick - thank you!
"Laura Cook" wrote: =SUMPRODUCT((Sheet1!B1:B3="ABC")*(Sheet1!C1:C3="In surance")*Sheet1!D1:D3) You can substitute the "text" for a cell that the criteria is entered into. "Anna Wood" wrote in message ... Not quite sure how to write the formula to return value for D1 in new worksheet. I need to match the values for both B1 and C1. B C D 1 ABC Insurance $100 2 ABC Taxes $200 3 DEF Insurance $150 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching 2nd & 3rd values | Excel Worksheet Functions | |||
| Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
| matching two values | Excel Discussion (Misc queries) | |||
| Matching Values | Excel Discussion (Misc queries) | |||
| Matching Values | Excel Worksheet Functions | |||
Linear Mode
