Log In
Register
Home
Active Member
August 20, 2019
Offline
Hi. This may be really simple to sum however I am having trouble with a formula.
I have a table of items and a number of times they have been issued. I need to look up the item number (C) and then add up the value in the quantity (E).
| Item | Quantity |
| 10012369 | 2 |
| 10049392 | 4 |
| 10069383 | 2 |
| 10012369 | 5 |
| 10049392 | 7 |
Thanks in advance!
See Answer
July 16, 2010
Offline
Hi Rebel,
Welcome to our forum!
There are lots of ways to achieve this, but it's not clear how you want the information presented. You mention looking up the item number (C) and then add up the value in the quantity (E), I'm guessing these are column references, but since you're not showing that information I'm not sure.
The simplest way to look up an item and return a value from a corresponding column is to use a VLOOKUP formula.
If you're still stuck after reading that post, please upload a sample Excel file with your data and desired output and we can help you further.
Mynda
Active Member
August 20, 2019
Offline
Hi Mynda
Thanks for your reply. I am brand new to this so forgive my ignorance.
I know how to do simple formula's like VLOOKUP's however from what I can gather from other posts, I need to do a VLOOKUP and a SUM.
What I am trying to do is lookup the instances of an item number in column C, add the number is column E and return the result in J, K, L for each item.
I have attached the file this time so hopefully, you'll see what I mean 🙂
Thanks, Rebel
July 16, 2010
Offline
Hi Rebel,
Thanks for providing the example file. It's clear now that you need a SUMIF formula. See file attached.
Mynda
Answers Post
1 Guest(s)
