Giving a Value to X

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a spreadsheet for a convention. One column is for a
certain group affiliation. By placing an X in the cell
they belong to one group. No x means they belong to
anither group. How can how write a fromula that results in:
Total A Group=
Total B Group=
Thanks, Bill
 
Bill,

=COUNTIF(A1:A100,"x")

This will pick up both upper and lower-case X. If this is ok, fine, if you
want say just lower-case x, try
=SUM(IF(NOT(ISERROR(FIND("x",A1:A100))),1,0))

which is an array formula, so needs tto be entered with Ctrl-Shift-Entrt.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Or somewhat shorter if case sensitive entered normally

=SUMPRODUCT(--(EXACT(A1:A100,"x")))
 
Peo,

I was expecting someone to improve upon it At least I stimulated the
thread.<vbg>.

As usual, a nice one!

Regards

Bob
 
Back
Top