I am trying to do what I believe is a simple multiple COUNTIF statement. The cells in column A are formatted as “General.” They will either contain an “x” or a “/”.
The “x” will equal a value of 1 and the “/” will equal a value of .5.
I can equate these values if I use a single COUNTIF statement. For example:
=COUNTIF(A2:A30,”x”) or I can use =COUNTIF(A2:A30,”x”)*1 to get a value of 1 for every “x” counted.
I can use =COUNTIF(H2:H32,"/")/2 to get a value of 0.5 for every “/” counted.
How can I combine these two statements for the same column so that if there are two “x’s” and one “/”, my result will be 2.5?

Thanks,

Kirk