Thread: Formula YTD
View Single Post
 
Old 12-03-2020, 05:09 AM
Christianu Christianu is offline Windows 10 Office 2016
Novice
 
Join Date: Dec 2020
Posts: 2
Christianu is on a distinguished road
Default Formula YTD

Dear all,
In a table I would like to sum up only all those cells, which are in the current year (C2:M2 in this case) to get a YTD-result (L2 in this case).
This is the table:


How is the (general) formula to do this?
Looking forward to your ideas. Cheers
Reply With Quote