x = 1

[Bryan De-Lara]

Hi all, I am fairly new to excel. I want to put x's into a column and make
each x = 1 then do a count further down. Then in the next column put an x to
= 2 then do another count and so on in more columns increasing the value of
x. I cannot seem to get anything to work. I've tried to put into a cell x=1
and so on but it doesn't work. Any help would be appreciated.

Bryan.

 

[Gordon]

Hi all, I am fairly new to excel. I want to put x's into a column and make
each x = 1 then do a count further down. Then in the next column put an x
to = 2 then do another count and so on in more columns increasing the
value of x. I cannot seem to get anything to work. I've tried to put into
a cell x=1 and so on but it doesn't work. Any help would be appreciated.

Bryan.

I'm a bit confused as to what you want to do. (And why?)
In Excel (as with all spreadsheet applications), a cell can either be text,
as in "x" or a number, as in "1".

 

[Sandy Mann]

With x's in Column A,

==COUNTA(A1:A25)

will cound *any* entry in the cells.


=COUNTIF(A1:A25,"x")

will count only the x's

In Column B use:

=COUNTIF(B1:B25,"x")*2

will count each x as equal to 2

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bryan De-Lara]

Thanks Sandy, just what I needed.
Gordon, it is 5 columns that has x's in rather than ticks. The headers
for the columns are 1 to 5. My boss didn't want numeric entered into the
cells which would have been easy to sum total. So I needed x to = 1 and so
on.
Thanks for the reply.

Bryan.

 

[Sandy Mann]

You are very welcome.

As I read in another post some time ago:
"there is nothing more dangerous than a manager with a spreadsheet" <g>

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk