Microsoft Office Forums - View Single Post - [Solved] Dynamically sum YTD by month

Thread: [Solved] Dynamically sum YTD by month

View Single Post

Old

06-24-2023, 10:15 AM

mmisogwebu mmisogwebu is offline

mmisogwebu is offline

mmisogwebu uses Windows 10

Windows 10 mmisogwebu uses Office 2021

mmisogwebu uses Office 2021

Office 2021

Novice

The original poster

Join Date: Jun 2023

Posts: 3

mmisogwebu is on a distinguished road

Smile

Quote:

Originally Posted by Pecoflyer

View Post

Something like

Code:

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

Thank you so much Pecoflyer for this

Reply With Quote