# Basic Sum Formula Question

#### Craig30

##### New Member
Morning All,
There is probably a very simple answer to this question, but being relatively new to Excel I'm not very knowledgable.

What I'm trying to do is get the total for a group of cells C16 though to C62 but only for the cells that have a numerical value in them.

That is, I want to count the number of cells that have a numerical value in them and disregard the cells that have "N/A" in them.

I have the formula for the total score "=SUM(C16:C62)" and the percentage "=C64/C63" but not able to work out the other bit.

Any help greatly appreciated...using Office 2000.

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Assuming your "N/A" is text and not an error value (otherwise =SUM(C16:C62) won't work), try

=COUNT(C16:C62) this counts all numerical values including zero

..or if you don't really need the SUM and COUNT except as a means to get the average just use

=AVERAGE(C16:C62)

Cheers Barry

That's exactly what I was after....cheers mate.

Replies
3
Views
106
Replies
3
Views
261
Replies
2
Views
130
Replies
6
Views
222
Replies
1
Views
458

1,196,098
Messages
6,013,437
Members
441,766
Latest member
ixruiz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back