Thread: Formula YTD
View Single Post
 
Old 12-03-2020, 11:39 PM
Christianu Christianu is offline Windows 10 Office 2016
Novice
  
Join Date: Dec 2020
Posts: 2
Christianu is on a distinguished road
Default Workbook
Sorry, I thought to have attached it. Here it is.


Problem is solved, btw.


Formula that works (in german):
=SUMMENPRODUKT((JAHR(A1:M1)=JAHR(M1))*(A2:M2))


Thanks anyways :-)
Attached Images
File Type: png 2020-12-03 13_05_44-Start.png (6.5 KB, 19 views)
Reply With Quote