Forum Discussion
Formula Help
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").
Cal, you can, but the question is how actually the price is defined. Is "2p" the text, or that's number formatted as 2p, and is that always "p" at the end of the price or that could be another notation. Better if you provide small sample file, with data as in your post, to illustrate formatting.
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").
- Thank you very much.
Cal
