arraysgoogle-sheetsgoogle-sheets-formulaarray-formulasgs-vlookup
Google Sheets - Perform VLOOKUP on every row in column and return sum
I have a spreadsheet where I have a column with some products in them. Each product has a price listed next to it. I have another sheet with sales, and a column has the product sold in the sale. I want a formula that produces the total price of every sale made, and products can be repeated.
Basically, if I have two products, A and B, with prices $1 and $2, then I have 3 sales, two of the sales use product A and one uses product B, the formula should return $4.
I tried using an ARRAYFORMULA with VLOOKUP and LOOKUP but no luck. Any help is appreciated, thanks.
Edit: Here is an example sheet as requested. Feel free to edit it. https://docs.google.com/spreadsheets/d/1obHa6lbxJl_tJlQ811kjJralb7GCGjHtYBkOEPCzxAk/edit?usp=sharing
Solution
use:
=ARRAYFORMULA(SUM(IFNA(VLOOKUP(Sales!C2:C, Products!A:B, 2, 0))))
- Convert 2d array rows to a consolidated associative 2d array by grouping on an identifying column
- While destructuring an array, can the same element value be accessed more than once?
- Avoid PHP notice when destructuring array
- Sorting with AlgoBuild. Why do I get an index is out of range error?
- How to use `static` with an array of array in C
- How do I remove random elements in one-go from an array using splice in Perl?
- Sum every cell in nth column with dynamic rows and columns
- ARRAY to XML without any libs in PHP
- VBA - Create empty array
- Reverse a string word by word except the last letter of each word
- change values in array when doing foreach
- C# generic method detect if T is array and then index into the array
- Method to find second highest number in an array in java
- How to store an array of objects in Local Storage?
- How to see if an array includes a nested array with specific values?
- How to fix my modal gallery on how to better improve the succeeding images
- How to send a property from an array of object from a child component to the parent component?
- How does jQuery make it so that its array-like collection objects are displayed like arrays in the browser console?
- Sort array of objects by one property
- Filter/Remove array object based on value, from nested JSON array object in JavaScript
- can't create an array of doubles
- Do Java arrays have a maximum size?
- How to select elements from array in Julia matching predicate?
- Array-size macro that rejects pointers
- Remove Specific Array Element, Equal to String - Swift
- Leetcode - Find the student that will replace the chalk
- Explanation of Python numpy array operations timing behavior
- Python - calculating pdf from a numpy array distribution
- VB.NET Regex.Replace not working (array not updating)
- How to generated N numbers in array that sum of these numbers is equal to 0