# why is report showing all items checked on form in one box on excel

**cfabickel**I have a form built that requires user to check boxes... when I run a report then everything that is in that question that has a box checked shows up in one cell in excel report... ??? how can this be stopped and each box checked show up in the report on a separate cell?

- JotForm Support Manager
**Jeanette**A better alternative would be to use matrix (under Survey Tools) and change the input type to

**Check Box,**that's the only way you'll get the options in separate cells. **cfabickel**tired this but I "HAVE" to be able to require at least and no more than a certain amount... I want to use this for voting purposes and football coaches are not very smart... :) I need a way to count and tabulate... I can do that on excel but I need each check box in its own cell

- JotForm Support
**jonathan**Hi,

It is not clear what you wanted to achieve here.

But base on this statement..

*but I "HAVE" to be able to require at least and no more than a certain amount... I want to use this for voting purposes and football coaches are not very smart... :) I need a way to count and tabulate...*I think the main objective is to

**Calculate**a result base on**checked items/options**You CAN achieve the counting and tabulation of the results by using

**Calculation**in the form.Check this user guide: http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

In your checkboxes options you can assign

**Calculation Value**for each option.The calculation values can then be tabulated/counted using Calculation.

Here is a demo jotform http://www.jotform.me/form/43006549165454 you can try.

Inform us if this can work on your requirement or not.

Thanks.

**cfabickel**I am not sure how this calculation would work for me... I need to calculate based on submissions not choices made on one form but many forms that are submitted. Here is an active ballot I made up... As you can see if I ask for 5 votes minimum on a question with 10 possible answers... what I get with your form is the 5 choices made all packaged together in one cell... I added DOTs to the info for the question basically so I can use excel and delimit the cell somewhat... the dots actually separate the words somewhat so I can extract the data into multiple cells ...

I need to be able to sum up the submissions though not the choices on one form...

**cfabickel**also, if I ever wanted to use this calculation option how do you see the calculations then and actually use it.. the image you gave me is much appreciated but I don't understand the values you entered and how its used...

- JotForm Support
**Welvin**A workaround I could think to accomplish this is to use COUNTIF Function in g.excel sheet. Here's how for example:

https://support.google.com/docs/answer/3093480?hl=en

http://spreadsheets.about.com/od/otherspreadsheets/qt/090804-google-spreadsheets-countif.htm

' your thoughts?

Thank you!

**cfabickel**I think you guys are missing my point... since all of the results are all in one cell for each voting item how would this COUNTIF Function work? A survey table would have worked but only if I could set preferences to require a min and max of checks as you can see I did on the check box one...

- JotForm Support
**Welvin**Here's an example: https://shots.jotform.com/welvin/userfile/12.xlsx (for column L). You can see the output in the

**result**tab.If you will use this method, you have to remove the

**dots**in the option and leave it a separate one so we can just wrap it and use this COUNTIF function.The formula:

**=COUNTIF(Submissions!$L$2:$L$6000,"*" & A2 & "*")**L stands for Column L in the Submissions tab. A2 is the column which results are search and tallied (result tab).

Let us know if you are confused and needs some clarification.

Thank you!