**juan7707**how can I count the number of boxes that were selected as NA in my matrix

I want to divide the result of each matrix if the column cumpio or no cumplio were selected, the NA it wasn´t to be counted.

- JotForm Support
**Chriistian**I checked your form (https://form.jotform.co/70469099638876 ). I noticed that the calculation value for the NA is not a numerical value that's why it is not counted.

Related Guide: How to Perform Form Calculation in the Matrix Field?

Please check and let us know if you need further assistance.

Regards **juan7707**i tried with a numeric value, but I can´t

What I need is that in the calculation field of the column NA is not considered in the numerator, but in the denominator it is weighted, for instance, if they are 4 rows, but one of them is selected as NA, then instead of dividing it Between 4, which is between 3. what do I have to do?

- JotForm Support
**Nik_C**Hello Juan,

So you would like that if it is selected like this:

To be calculated 100%. 3x100 divided by 3 because N/A is selected?

Let me check this further and I'll get back to you ASAP.

Thank you!

**juan7707**Exactly that's what I need

- JotForm Support
**Nik_C**I just wanted to follow up, I tried to make this work, no luck so far.

But, I'll try more to make it work and I'll certainly get back to you.

Thank you for your patience.

**juan7707**I found an alternative solution, it's fixed

but if you find a easiest way to work it out that a wil be great

- JotForm Support
**Nik_C**Hello,

I'm sorry for this delay.

I tried to make this work, but all solutions I came to are very complicated and not elegant. I tried to make a logic that will hold the data when NA option is clicked and then use that value to deduct from number 4, which is used to divide. But then, later, there is a problem with values used in a calculation, so I'm not getting the round number. Anyhow, that solution would require a lot of new fields and new calculations for each matrix field.

If you came up with a solution that is workable for you, please try with it and feel free to share.

If I find some other solution with this setup I'll get back to you.

Thank you!