How to use the count function?

[atech]

Hello,

I have two questions, I hope you can help me with.

Question 1:

I’m trying to use the count function, what I want to do is:
Count the X’s the X’s = 1
Count the O’s the O’s = 1

and

Count the –‘s the –‘s = 0.5

So let’s say in

A1 has an X
B1 has an X
C1 has an –
D1 has an O

And the count formula will go in A2 and A3

A2 will count the X’s and –‘s and
A3 will count the O’s

My problem is how do I count the –‘s?

So there should be a total in A2 and A3

A2 should have a total of 2.5 because X’s equals 1 and –‘s equals 0.5

And A3 should have a total of 1 because O’s equals 1

How do I add the 0.5 to the total of the X’s using the count function?


My Second Question is really simple

Question 2:

I’m just wondering what the difference is here, when you right click on a cell and hit format cells and under category click on number and under negative numbers it gives you the options of:

-1234.10
1234.10
(1234.10)
(1234.10)

I just want to know what the difference are between them.

I Hope I explained myself correct

Thank you for your help

[daddylonglegs]

TRy using COUNTIF, e.g. in A2

=COUNTIF(A1:D1,"X")+COUNTIF(A1:D1,"-")/2

[atech]

Thank you daddylonglegs works like a charm...