Sumproduct condition as range

[Delta729]

I'm trying to make a sumproduct formula that would count several different types of text that is in the CG-type column. I have it working when it looks at only the cells that are in cell P23, but I would to change that to a range of cells or array like P23:P27. Any ideas to make that work.

Please Login or Register  to view this content.

I hope that makes sense. Just let me know if not.

[daddylonglegs]

You can use MATCH to match against a range of cells like this:

SUMPRODUCT(--(TEXT(DataTbl[Date],"mmm")=J12),--(YEAR(DataTbl[Date])=J11),--(DataTbl[Group]=H15),--ISNUMBER(MATCH(DataTbl[CG-type],P23:P27,0)))

[Delta729]

Perfect. Thank you so much! That works perfectly for counting. Now, I just modified the formula to sum the voucher counts.

Please Login or Register  to view this content.

Can you tell me how to modify that so it works.

**I marked this thread as solved to soon before editing my reply**

[Delta729]

Never mind, I got it. Thanks for your help.

Please Login or Register  to view this content.