Formula YTD

Christianu · #1 12-03-2020, 05:09 AM

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

Logit · #2 12-03-2020, 09:46 AM

Post your workbook.

Christianu · #3 12-03-2020, 11:39 PM

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 :-)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with a formula	santors71	Excel	10	06-19-2018 02:43 AM
Formula Copy Row 2 Row But Next Column In Formula From Another Tab	TimG	Excel	3	04-16-2018 09:20 PM
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
Formula Help - Look and if and that	Corca	Excel	2	02-05-2012 09:18 AM