# Calculating columns and showing in a view

All,

I have a very large list (3000+ items). I need to show a view of this data. I need to show a count of every row (3 rows) of all the YES drop downs. The drop down rows may contain YES or NO. So I need a count of all the YES. I do not want to see the data in the view. I just want to see the count only. Any ideas ?

I just need a list or a view, that shows the three rows (A,B,C (which are YES/NO Columns). With each row showing the count of the YES's . but no data.. Hope this is clearer.

• With or without code? May 18, 2016 at 14:44
• You can get this done via JSLink. Attach a javascript file to your view and do the calculation. A similar question was asked before here sharepoint.stackexchange.com/questions/129727/… May 18, 2016 at 14:59
• without code please. OOTB only May 18, 2016 at 15:25
• Does this need to be in the view with the data, or can it be in a separate KPI list? May 18, 2016 at 15:36
• Hi @Jammin4CO yes it can be an seperate list. I need the ammount of YES on three different rows and it needs to be displayed horizontally. The original list can be left as is. May 18, 2016 at 15:44

I need to show a count of every row (3 rows) of all the YES drop downs.

You mean 3 columns/fields in one item ??

Since a True/Yes value equals 1 and False 0

You can use the SUM() function (up to 30 parameters)

``````=SUM( [Field1] ,  [Field2] ,  [Field3]  )
``````

### Update #1

OP wants the sum of a column and not display the column in the view

That is not possible out-of-the-box, can only be done with code

• yes each row has 3 YES/NO columns. I want to count the YES's on each column, but I dont want to see any results - i just want to see the COUNT. OOTB only if you have any ideas. May 18, 2016 at 15:27
• If you don't want the "results" (by which I assume you mean the yes/no columns), simply don't include them in your view. May 18, 2016 at 15:33
• if i dont incluse them in my view, i dont get the count. I need the count. In the view you can add the count - thats all i need to see. May 18, 2016 at 15:37

Here is the closest I can get for you.

1. Make a view that has the columns you want to count.
2. In that view, in the Totals section add count totals.
3. In the Item Limit section, make batches of 1

This should get you in the right direction. You may have to have a separate view with filters for each column to get accurate totals. I also noticed in my testing that if you use the Yes/No column, the total only returns a count of "Yes".