Problem with " in sumproduct

[lynnsong986]

Hello,

I have a formula as it is, without using reference to a cell :

=SUMPRODUCT((RevenueData)*ISNUMBER(MATCH(RevenueItems,{"Admin and Meter Fees (Existing & Rental Retrofit)","Admin and Meter Fees (New Condo)","Admin Fees Students","Account Setup Fees","Disconnect/Reconnect Fees","My new line","Your New Line"},))*(Years=G$2))

I wish to have the array constants in a cell as these will be returned by a userform, if I put this string in cell F14
{"Admin and Meter Fees (Existing & Rental Retrofit)","Admin and Meter Fees (New Condo)","Admin Fees Students","Account Setup Fees","Disconnect/Reconnect Fees","My new line","Your New Line"}

and change the formula to
=SUMPRODUCT((RevenueData)*ISNUMBER(MATCH(RevenueItems,F14,))*(Years=H$2))

it didn't work and by pressing F9, I got the attached evaluation, I tried to use indirect but the result is the same.

can someone please make this work?

thanks!

[TMS]

Looks like you have an extra comma after the closing curly bracket.

Please Login or Register  to view this content.

[lynnsong986]

OMG I didn't notice it!! thank you so much for your help!

[TMS]

You're welcome. Thanks for the rep.

Easily missed. Hope that resolves your issue.

[lynnsong986]

yes it did, now it finally works! thanks a ton!

[TMS]

No problem.