Jan 10 2020 07:11 AM
Hi,
I fairly new to Excel and have been trying to solve this issue for almost a day now. I am trying to 'automate' a part of my budget excel sheet through the use of an IF statement that includes a nested formula. I have added a small example of my excel sheet to the appendix of this post.
The excel sheet has two tabs; dashboard and transactions. I need the sheet to do the following.
So far I've got the following formula.
=ALS(B15=ABN_Amro_Transacties_Januari[Maand];SOM.ALS(ABN_Amro_Transacties_Januari[[#Alles];[Categorie]];"Boodschappen";ABN_Amro_Transacties_Januari[Bedrag]);"Error")
First it checks if the Month in Column on a different tab matches the month at B15
If it does, the following SOM.ALS (SUM.IF) checks if the category column contains a certain word, in this case it's 'Boodschappen' (Groceries). If it does, the formula should grab the value in the 'Bedrag' column and add it to the total value of the category.
Hopefully you understand. I would appreciate the help greatly.
Kind regards,
Jason
Jan 10 2020 05:09 PM
SolutionWhy not build a simple pivot table?
Maand in columns area.
Subcategorie in rows area.
Bedrag in values area.
Jan 10 2020 05:09 PM
SolutionWhy not build a simple pivot table?
Maand in columns area.
Subcategorie in rows area.
Bedrag in values area.