I have done a shopping cost sheet, which obviously has the date column in DD/MM/YY format. I have "Purchase Item type" and "Amount" column as well, I have a separate table to get Monthly Cost by Purchase Item Type.
I am not sure how to get the Total Amount by Purchase Item Type by the Month;
Eg How much I have spend in Groceries, Vegetables, etc.
Which formula I could use?
I have got the whole total amount till January to now by this formula;
=SUMIFS(Table1[[#All],[Amount]],Table1[[#All],[Purchase Item Type]],[@[Purchase Item Type]])
Need further help; thanks
Bookmarks