I have a massive spread sheet, single tab, but thousands of lines.
Multiple customers, various part numbers, and quantities.
Attached is a very consolidated example.
I'm trying to zero in on a specific part number, (366102) it will always be that specific part number, take all the quantities for that specified part number, sum them, then multiply them by 25, and that is my Output.
So in the example sheet, I would expect the output, with nothing filtered, to be 1200.
That's the base of the formula, but I want the output to change based on the filtered customer.
So in my example spreadsheet, if I filter by customer Foxtrot, I would expect my output to change from 1200 to 400.
I hope that makes sense.
I really appreciate the help.
Bookmarks