Dynamically sum YTD by month

		Microsoft Office Forums > Microsoft Excel > Excel
Dynamically sum YTD by month

06-24-2023, 10:15 AM

mmisogwebu mmisogwebu is offline

Windows 10 Dynamically sum YTD by month

Office 2021

Novice

Join Date: Jun 2023

Posts: 3

Quote:

Originally Posted by Pecoflyer

Something like

Code:

=SUMPRODUCT(--(MONTH(C3:H3)<=MONTH(B1))*(B4:B7=C12)*C4:H7)

Thank you so much Pecoflyer for this

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamically protect word doc	fops	Word VBA	3	03-24-2023 08:59 PM
Can you dynamically size a row to fit a Text Box	indelg1	Excel Programming	1	02-14-2022 04:36 AM
Applying styles dynamically?	arkofcovenant	Mail Merge	1	05-08-2015 06:02 AM
Dynamically create documents	MrRikkie	Word VBA	1	10-12-2012 09:15 AM
draw charts dynamically	pouya7525	PowerPoint	0	09-06-2012 10:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:31 PM.