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").
I can't show my data as it contains sensitive info.
Please find attached a mock layout etc.
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").