Need formula help

missaimee

Board Regular
Joined
Dec 15, 2004
Messages
136
If I want to use "x"'s in a field but need to be able to count them, how would that formula look? Let's say the fields looked like this:

Staff A B C D
Name 1 x
Name 2 x
Name 3 x
Name 4 x
Name 5 x
Name 6 x


and on another sheet I will have this:

A B C D
Totals
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Is this what you mean?

=COUNTIF(C2:C7,"x")
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Take a look at COUNTIF().

I.E. =COUNTIF(A:A,"x")

HTH,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,111,491
Messages
5,541,034
Members
410,542
Latest member
GDiddy1984
Top