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 xs and one /, my result will be 2.5?
Thanks,
Kirk
Bookmarks