### iDoceo 8 for iPhone,iPad and Mac now available!

You will find all the details explained here

## How to Use Numcol function 4 years 5 months ago #7351

 Freen OFFLINE Junior Member Posts: 4 I am trying to understand the Numcol (count columns) function. I thought I could provide a range of columns and it would count how many columns there were included but it does not seem to work that way. Also, is it possible to count the number of columns in a category so if you add more columns to the category the count changes accordingly automatically? I'm new to all of this so any help you can provide would be greatly appreciated. Thank you. The administrator has disabled public write access.

## How to Use Numcol function 4 years 5 months ago #7352

 bert OFFLINE Admin Posts: 3485 Thank you received: 686 Hello Freen, NUMCOL counts the number of non empty cells in a list of columns but it usually is not required. Let me know the kind of calculation you're trying to do. In a category, any calculation except the formula will automatically take into account the new columns you add in it. Please take a moment to add or update your rating for iDoceo 7 teacher gradebook so that we can continue working on it. Thanks! Here is the link apps.apple.com/app/apple-store/id4771209...&action=write-review The administrator has disabled public write access.

## How to Use Numcol function 4 years 5 months ago #7353

 Freen OFFLINE Junior Member Posts: 4 Thanks Bert, Essentially I am trying to add up bonus participation points for a warm-up routine kids do at the beginning of most classes. As it is not every class, I would be adding columns as I go instead of having a set number of columns in advance. Now this is pretty easy except I would prefer to not have to give a code for every student but be able to leave some spaces blank but still have that space count towards the number of total warmups. So I need to count the number of columns (preferably in a category folder) so I can use that number to divide to get a percentage (ratio of times they got the bonus out of the number of opportunities). But I can't figure out how to leave a cell blank but still have it counted towards a total. Hope that makes sense. Thanks! The administrator has disabled public write access.

## How to Use Numcol function 4 years 4 months ago #7367

 Freen OFFLINE Junior Member Posts: 4 Funny enough that is what I set up on my own. I was just hoping that there was a way that I could avoid having to fill every cell - instead having an empty cell count as a predetermined value. So empty = default value in essence. The administrator has disabled public write access.

## How to Use Numcol function 4 years 4 months ago #7374

 Freen OFFLINE Junior Member Posts: 4 Ya unfortunately I will not know in advance how many columns I will need to count so for now I will just have to make a mark in every column for every student instead of leaving some blank. The administrator has disabled public write access.
Time to create page: 0.111 seconds
21 AUG

iDoceo 7 for iPad and Mac now available!

A huge update with tons of new features and a new interface

6 JUN

Create Multiple-choice tests with iDoceo Connect!

In addition to self-evaluation rubrics, your students can now fill exams online. Supports text and images - in answers and questions - and can easily be imported from an XLS template