Matching two values

A

Anna Wood

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
 
L

Laura Cook

=SUMPRODUCT((Sheet1!B1:B3="ABC")*(Sheet1!C1:C3="Insurance")*Sheet1!D1:D3)

You can substitute the "text" for a cell that the criteria is entered into.
 
A

Anna Wood

That did the trick - thank you!

Laura Cook said:
=SUMPRODUCT((Sheet1!B1:B3="ABC")*(Sheet1!C1:C3="Insurance")*Sheet1!D1:D3)

You can substitute the "text" for a cell that the criteria is entered into.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top