#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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 |
#3
|
||||
|
||||
|
#4
|
|||
|
|||
Thank you so much Pecoflyer for this
|
#5
|
|||
|
|||
Solved by Pecoflyer
|
|
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 |