Compare two columns with another two columns and return
Closed
Ree1931
-
Oct 30, 2015 at 12:41 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 2, 2015 at 11:02 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 2, 2015 at 11:02 AM
Related:
- Compare two columns with another two columns and return
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- Beyond compare - Download - File management
- Zuma return - Download - Puzzle
- How to delete rows and columns in word - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 2, 2015 at 11:02 AM
Nov 2, 2015 at 11:02 AM
Hi Ree1931,
I put you sample data in the range A1:C4.
Then I used range F2:H2 for Zip code, City and formula:
=SUM((A2:A4=F2)*(B2:B4=G2)*(C2:C4))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter instead of just Enter.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
I put you sample data in the range A1:C4.
Then I used range F2:H2 for Zip code, City and formula:
=SUM((A2:A4=F2)*(B2:B4=G2)*(C2:C4))
This is an array formula and needs to be confirmed by hitting Ctrl+Shift+Enter instead of just Enter.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.