Mar 09 2020 07:42 AM - edited Mar 09 2020 08:02 AM
I love using the SOMMEN.ALS function (sums.if) for my personal budget spreadsheet.
But now I want to do something that I can't figure out how.
I have a tab that I use to track on which days my periodic expences are paid (rent, utilities, health insurence, etc.) I want to make a fomula so I can automatically see the date on which this expence has been paid when the expence name and the month match.
So if colom B says 'rent' and colom C says 'March' on the same line, I want the cel to show the date noted in colom A. But I can't figure out how to do it.
I have found online something about the formula's Index and Match, but I can't figure out how to construct them for my case
The normal ALS (IF) function doest work for what I want. who could help me?
Mar 09 2020 07:50 AM
Mar 09 2020 08:02 AM
@Savia I have tried this, but it doesnt work. I have found online something about the formula's Index and Match, but I can't figure out how to construct them for my case
Mar 09 2020 08:22 AM
Mar 12 2020 01:41 AM
it first gave me a value of 0-jan, which is nothing. But it turned out I messed somthing up. so it works now.
Now when the formula can't find a line fulfilling all the criterum it gives the 0-jan response. is there a way to construct the formula to substitute that for an 'X'?
by the way, thank you so much for helping me. I really appriciate it.
also, sorry for my crappy spelling and explanation. English is my 2nd language, and I have to translate the formula's from my native tongue to English, and that doesnt always go well.
Mar 12 2020 03:22 AM