Sumproduct calculation vba

[Av8tordude]

How can I use this formula in vba...

=SUMPRODUCT(--(TEXT($D$15:$D$1001,"mmmmyyyy")=$S23&T$14),$P$15:$P$1001)

Thank you kindly

 

[Av8tordude]

Would you mind answering the second question :

cbMon will have the Months (i.e. January, February, etc.) and cbYr with have the years (i.e. 2018, 2019, 2020, etc)

 

[MARK858]

I think you will find that James006 wants you to confirm that they are both Comboboxes
I think you also need to confirm that the months are the months names and not the month number.

 

[Av8tordude]

They are combo boxes and the months will be Names and the Years will be numbers

 

[Av8tordude]

Could someone assist with offering a solution to my request. Thanks

 

[James006]

Have you tested :

CCI.Caption = Evaluate("=SUMPRODUCT(--(TEXT(D15:D1001,""mmmmyyyy"")= " & cbMon & cbYr & ",P15:P1001)")

 

[Av8tordude]

Have you tested :

CCI.Caption = Evaluate("=SUMPRODUCT(--(TEXT(D15:D1001,""mmmmyyyy"")= " & cbMon & cbYr & ",P15:P1001)")

yes...that was the first thing I tried but it gives me an error

 

[RoryA]

You need some quotes for your text values:

CCI.Caption = Evaluate("=SUMPRODUCT(--(TEXT(D15:D1001,""mmmmyyyy"")= """ & cbMon & cbYr & """,P15:P1001)")

 

[Av8tordude]

Sorry Rory, but it still gives me an error.

 

[Rick Rothstein]

Does this work for you...

[table="width: 500"]
[tr]
	[td]CCI.Caption = Evaluate("SUMPRODUCT(--(TEXT(D15:D1001,""mmmmyyyy"")=""" & cbMon & cbYr & """),P15:P1001)")[/td]
[/tr]
[/table]

 

[Av8tordude]

Works Perfect!!!!! Thank you sooo much to everyones for help. I really appreciate it A LOT!!!

Does this work for you...

[TABLE="width: 500"]
<tbody>[TR]
[TD]CCI.Caption = Evaluate("SUMPRODUCT(--(TEXT(D15:D1001,""mmmmyyyy"")=""" & cbMon & cbYr & """),P15:P1001)")[/TD]
[/TR]
</tbody>[/TABLE]