Formula YTD

		Microsoft Office Forums > Microsoft Excel > Excel
Formula YTD

FAQ

Thread Tools

Display Modes

12-03-2020, 11:39 PM

Christianu Christianu is offline

Windows 10 Formula YTD

Office 2016

Novice

Join Date: Dec 2020

Posts: 2

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

2020-12-03 13_05_44-Start.png (6.5 KB, 19 views)

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:09 PM.