Forum Discussion
conditional sum by matching name and date
Hi, I´m trying to build a financial template for personal use and I seem to have walked into an issue regarding a SUMIFS- (German: SUMMEWENNS) formula. FYI JAHR(=YEAR) =SUMMEWENNS(Tracking[Am...
The 2nd, 4th etc. arguments of SUMMEWENNS must be ranges. They cannot be expressions such as JAHR(Tracking[effective_date]).
Try this:
=SUMMENPRODUKT(Tracking[Amount]; (Tracking[Type]=type)*(JAHR(Tracking[effective_date])=selected_Jahr))
