|
|
#2
06-24-2023, 07:55 AM
|
||||
|
||||
Something like
Code:
=SUMPRODUCT(--(MONTH(C3:H3)<=MONTH(B1))*(B4:B7=C12)*C4:H7)
__________________
Using O365 v2503 - 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 
|
|
|
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 |
Windows 10 
Office 2021
Threaded Mode