Reference another sheet to return quantities from multiple rows
Hi all -
I am building sheets with corresponding forms to allow individuals to receive and distribute supplies across several locations.
What I need: a master inventory sheet reference other sheets, specifically for an item name and the quantities received. The quantities received will have multiple continuous entries (rows) over time, owing to the forms used to receive these items.
When I utilize VLOOKUP it will only return the first match it finds:
What formula, or combination of, could be used to return those totals from multiple rows?
Thank you.
Best Answer
-
Hi @priley89
It sounds like a SUMIF Function would work for you!
A SUMIF works like this:
=SUMIF({Column with Criteria}, "Criteria", {Column to Sum})
So in your case, something like this:
=SUMIF({Total Received Column}, [Item Name]@row, {Item Name Column})
Let me know if this returns your expected result.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @priley89
It sounds like a SUMIF Function would work for you!
A SUMIF works like this:
=SUMIF({Column with Criteria}, "Criteria", {Column to Sum})
So in your case, something like this:
=SUMIF({Total Received Column}, [Item Name]@row, {Item Name Column})
Let me know if this returns your expected result.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you very much for the prompt response!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!