is there a COUNTIF formula?

[Glenlim]

Hi,

I have two separate spreadsheets and would like to know what tools can be used to calculate the number of times portfolio data appears in Code data.

I've attached the sample data below. 

Thanks!

[JosephSerpis · Accepted solution]

Hi @Glenlim you would need to use a combination of the Join tool and the summarise tool to achieve the equivalent countif in excel. I mocked up one approach to demonstrate this.

[Bren_Spill]

Hi,

Please see attached sample workflow.

Thanks,

[jrgo]

[Glenlim]

Hi,

I am unable to download file. Could you post as a picture please?

Thanks!

[Glenlim]

@JosephSerpis  Am not getting the same as you. 

What's the configuration for the Join and Unique tool?

Thanks