Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Dynamically sum YTD by month Dynamically sum YTD by month
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-23-2023, 12:49 PM
mmisogwebu mmisogwebu is offline Dynamically sum YTD by month Windows 10 Dynamically sum YTD by month Office 2021
Novice
Dynamically sum YTD by month 		 
Join Date: Jun 2023
Posts: 3
mmisogwebu is on a distinguished road
Default Dynamically sum YTD by month
I have this excel sheet whereby i want to sum Dynamically the YTD for the selected product for multiple occurrences in a row.



The formula i have used is suitable for 1 Row only.
Kindly assist experts and thanking you in advance for your assistance.
Attached Files
File Type: xlsx YR TO DATE SUM (4).xlsx (10.6 KB, 5 views)
Reply With Quote
  #2  
Old 06-24-2023, 07:55 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Dynamically sum YTD by month Windows 10 Dynamically sum YTD by month Office 2021
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,779
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
Something like
Code:
=SUMPRODUCT(--(MONTH(C3:H3)<=MONTH(B1))*(B4:B7=C12)*C4:H7)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 06-24-2023, 08:58 AM
p45cal's Avatar
p45cal p45cal is online now Dynamically sum YTD by month Windows 10 Dynamically sum YTD by month Office 2021
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Cross posted Dyanamic YTD sum for multiple occurrences | Chandoo.org Excel Forums - Become Awesome in Excel
Reply With Quote
  #4  
Old 06-24-2023, 10:15 AM
mmisogwebu mmisogwebu is offline Dynamically sum YTD by month Windows 10 Dynamically sum YTD by month Office 2021
Novice
Dynamically sum YTD by month 		 
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
  #5  
Old 06-24-2023, 10:26 AM
mmisogwebu mmisogwebu is offline Dynamically sum YTD by month Windows 10 Dynamically sum YTD by month Office 2021
Novice
Dynamically sum YTD by month 		 
Join Date: Jun 2023
Posts: 3
mmisogwebu is on a distinguished road
Default
Solved by Pecoflyer
Reply With Quote
Reply

« Previous Thread | Next Thread »


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 sum YTD by month 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 09:52 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft