Microsoft Exel Formula I Need Some Help?

Question

I want to be able to sum names individually in a row.

Example: In Cell A1, A2, A3

John Doe
Jane Doe
James Smith

Total: 3

I need the sum to be the total names I input. So if I have 50 blank cells and I enter only 30 names, I need a sum of 30. Make sense?

Answer 1

To count nonblank cells, use the COUNTA function.
Counts the number of cells that are not empty and the values within the list of arguments. Use COUNTA to count the number of cells that contain data in a range or array.

Syntax

COUNTA(value1,value2,...)

Value1, value2, ... are 1 to 30 arguments representing the values you want to count.

Remarks

A value is any type of information, including error values and empty text (""). A value does not include empty cells.
If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
If you do not need to count logical values, text, or error values, use the COUNT function.
Example

The example may be easier to understand if you copy it to a blank worksheet.

Answer 2

I will use your example of 50 blank cells to answer this.

If you want to use 50 vertical blank cells (A1 to A50), and use A51 as the place to put the total, then you would use this formula in A51.

=COUNTA(A1:A50)

This will look at cells A1 to A50 and determine if there is any type of input in those range of cells. Warning though, if you accident put a space in a blank cell, it will count that as an input. The input can be numbers, text, whatever. Also, not to patronize you, but make sure you use COUNTA and not COUNT which will only count numerical inputs.

Hope this helps.

Answer 3

You can use two functions [ 1. COUNTA() and 2. COUNTIF() ]to get the desired result.

1. As suggested by spreefx, you can use the COUNTA() function.

2. Else, you try the following:

= COUNTIF(A1:A50,"*")

This will also give you the desired result. Another advantage of the COUNTIF() function is that, instead of "*" wildcard, you can count names starting with any letter(s). For example, if you want to count the names starting with G, then you can use like
= COUNTIF(A1:A50, "G*")

Answer 4

Excel formulas only work with numbers not with filled boxes. Try starting your list on A5 or A10 to make counting the total names you have easier.
I tried the count function...it didn't work for me.

Answer 5

Use this:
=SUM(A1+A2) And so, I think you get it :) Put that in the final cell.

Answer 6

First elect each of the cells you want to rearrange in descending order and click variety on the toolbar (or flow to records -> variety). you are able to elect numerous columns for this fuction and it is going to variety each of the cells in words of their position. To get the similar old of any row or column elect each of the cells and click Insert -> function -> Statistical -> conventional this provides you you with the similar old of the selected cells.

Answer 7

under Tools, select subtotals, instead of sum use the count in the drop down.