Forum Discussion
Obtaining all values in a specific column with a fixed lookup (text) value [Solved]
Hi everyone, I'm trying to figure out a smarter and more convenient way to sum multiple cells with a fixed lookup value in an extensive sheet. Using a vlookup, or an index-match gives the first v...
in the absence of an actual spreadsheet from you (an image is of some, but limited, use) I can point in the direction of a couple of possible solutions.
- Have you tried the SUMIF function? That might do it: it will sum a given column based on a criterion or criteria you specfiy.
- And if you have the newest version of Excel, there are some Dynamic Array functions that might work in conjunction with other summing functions.
- Of course, there's also the Pivot Table which would do every product by month it's perfect for cross-tabulated summary reports.
Might I suggest you upload an actual representative file, if not your actual file (which may contain proprietary info) if you'd like more specific help.
- I initially also tried the SUMIF, but I must have made a mistake because it works now.
Thanks for the reply on this silly question!
