Counting only rows with a 1

Question

Hey All,

I have a the below Dummy data set and what I need to do is only get a count of the rows per name that contain a 1 so if there is a 0 we don't care about it essentially.

so like in the case of Dean it should just be a count of 3 and so on.

This might be a simple task but I cant see  way to do it after trying various approaches already.

Sample data:

NamePresent_or_NotYearDean12023Dean12023Dean12023Dean02023Dean02023James12023James12023James02023Liam02023Liam02023Liam12023Liam12023Liam12023Liam02023Liam02023

Cheers to you all in advance.

FinnCharlton · Accepted Answer

Hi @Deano478 , you can do this by filtering to just the '1's and then counting the rows:

Another approach could be to replace the 0s with NULLs and then use the "Count Non Null" functionality of the summarize tool. Hope this helps!

binu_acs · Accepted Answer

@Deano478 One way of doing this with the summarise tool after changing the 0's to NULL value

ShankerV · Accepted Answer

Hi @Deano478

One way of doing this.