How can I calculate the total sum of row values in the sheet?

Row1: 5
Row2: 2
Row3: 3
Total count=10


I have the following array:
{Apple, banana, Apple}

How do I count the following?

Apple count = 2
Banana count =1

Is it an array column in the builder, or you have it in pure text form?

I think JavaScript is the way to go here, but I’m curious if you have a table where you store all types of fruits and you can use a joined list column for this.

If you can describe more about your use case, that’d be great.