Alteryx Substitute for Sum Product =SUMPRODUCT(--(A1:A6=225))

[ashaw7]

Hey Everyone,

Looking for a Alteryx substitute for the below formula:

=SUMPRODUCT(--(A1:A6=225))

I have a unique order number and a Delivery Creation Date - I create a unique xref using this which results in this format (7207362363144187) on my Delivery Checks

I have a data spreadsheet in which data is extracted from into my Delivery Checks.

I'm trying to create the same xref format of (7207362363144187) but keeps formatting as (72073623632020-05-22) 

I then need to use =SUMPRODUCT(--(A1:A6=225)) to bring back how many times this unique ref comes back on the spreadsheet.

Countif doesn't recognise the 44187 date part as a unique value so that is why I use the above formula.

But I'm trying to automate my work but I cant seem to figure out a tool or method to produce the same output.

I need the spreadsheet exactly how it is just another column added at the end with the correct count in.

Appreciate your support

thanks 

[JagdeeshN]

Hi @ashaw7 ,

Please find below certain community discussion around the same function:-

1. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Sumproduct-Excel-formula-in-Alteryx/td...

2. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Sumproduct/td-p/635286

3. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Simulate-sumproduct-Excel-formula-in-A...

Please do let me know if any of these solutions apply to your usecase.

Best,

Jagdeesh