Forum Discussion
Solved
Formula Help
Hello all, I'm trying to see if there's a way to make this happen automatically in excel. If I have a list several (including multiples) items and in another column I have the cost price, is there ...
Thank you. We don't need your entire file, just what is on screenshot but as file.
If I understood correctly you'd like to sum (OUT) by Item, perhaps by month/year as well. When PivotTable will be a right solution. As option SUMIFS(out column, item column, "Apples").
This data structure is some different from the screenshot.
Couldn't see the previous answer to understand better. For me the whole thing always hangs a bit, somehow I get the updates in the forum always delayed ... strange. Anyway it is how it is, do you carry on?
Usually I refresh before answer, previous post doesn't appear automatically. Anyway, it's always better to have the sample, we may have a lot of guesses on what is actually required.