# How do I count two column..? **URL:** \ **Category:** Ask for Help\ **Created:** [February 9, 2023, 4:08am UTC](https://community.glideapps.com/t/how-do-i-count-two-column/57684 "2023-02-09T04:08:13Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 9, 2023, 4:08am UTC](https://community.glideapps.com/t/how-do-i-count-two-column/57684/1 "2023-02-09T04:08:13Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/4/b465232337c8db51a3af88aa8357c40f2e317497.png) Hi all, I want to count number of symbols in the column by the same email. So that it should look like if I use rollup - count: User A RTY 1 User A NQ 1 User A ES 1 User B RTY 1 User B ES 2 User B NQ 2 User B NQ 2 User B ES 2 I tried making self relation and some options to count it but it just counts all of the same symbol by all users and does not work the way I expected. For your reference there are lots of symbols (not just 3) so I can’t use if then else function. Can anyone help please? ---
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 9, 2023, 4:11am UTC](https://community.glideapps.com/t/how-do-i-count-two-column/57684/3 "2023-02-09T04:11:27Z")
I wish it was that easy. Of course I tried this and making relation column connecting email or symbol. But did not work ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 9, 2023, 4:20am UTC](https://community.glideapps.com/t/how-do-i-count-two-column/57684/4 "2023-02-09T04:20:33Z")
It’s pretty close to that easy. Just create template column that joins the email and the symbol together. Then create a multiple relation column that links the template column to itself. Finally create a rollup column that uses that relation. That is the foolproof way to do it, but the way you did it with just the symbol will also work because you are currently using row owners. It might not appear that way in the data editor, but the count will only be for one user on the front end because of row owners. ---
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 9, 2023, 4:27am UTC](https://community.glideapps.com/t/how-do-i-count-two-column/57684/5 "2023-02-09T04:27:14Z")
Hi thanks for the reply. I don’t quite get how to join these two values using template column. Can you explain please? ---
**Author:** ![rezmeplx](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rezmeplx/32/53827_2.png) [@rezmeplx](https://community.glideapps.com/u/rezmeplx)\ **Post date:** [February 9, 2023, 4:30am UTC](https://community.glideapps.com/t/how-do-i-count-two-column/57684/6 "2023-02-09T04:30:53Z")
I actually figured it out. Thank you. Never thought of using template column this way. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 10, 2023, 4:31am UTC](https://community.glideapps.com/t/how-do-i-count-two-column/57684/7 "2023-02-10T04:31:27Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.