Forum Discussion
Beginner needs help with a nested formula
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. Instructions overview
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
Why not build a simple pivot table?
Maand in columns area.
Subcategorie in rows area.
Bedrag in values area.
2 Replies
- JasonNLCopper Contributor
Anyone?
- Detlef_LewinSilver Contributor
Why not build a simple pivot table?
Maand in columns area.
Subcategorie in rows area.
Bedrag in values area.