tiffanyfit3d
New Member
- Joined
- Oct 4, 2017
- Messages
- 4
Hi all!
First time to the forum but I've got a doozy of a problem and can't seem to find any answers. Hoping you guys can help!
I have Table A with a bunch of invoice numbers and quantities. I have Table B that also has invoice numbers on it. There are some entries only in Table A, some only in Table B, and some in both. I need a formula that will sum the quantities of invoice numbers that are ONLY in Table A.
Example:
Table A
Table B
Result: 5
I know that I could add a third column to Table A and do a vlookup and then sumif on #N/A but I want this to just be a template where I can paste my data and the result spits out.
Any thoughts?
Thanks in advance!
-Tiffany
First time to the forum but I've got a doozy of a problem and can't seem to find any answers. Hoping you guys can help!
I have Table A with a bunch of invoice numbers and quantities. I have Table B that also has invoice numbers on it. There are some entries only in Table A, some only in Table B, and some in both. I need a formula that will sum the quantities of invoice numbers that are ONLY in Table A.
Example:
Table A
Inv# | Qty |
1065 | 3 |
1077 | 1 |
1083 | 5 |
1086 | 2 |
Table B
Inv# |
1069 |
1077 |
1083 |
1090 |
I know that I could add a third column to Table A and do a vlookup and then sumif on #N/A but I want this to just be a template where I can paste my data and the result spits out.
Any thoughts?
Thanks in advance!
-Tiffany