A
Adel Handal
Hi,
I had this before, but it didn't work weel! I may have not made it clear.
Range C5:C29 containes either letter C or letter M.
Range D529 containes either letter M or letter F
line 5 C F
line 6 C M
line 7 M M
...........
In cell D34 I want to count the number of occurance of the combination of C
and M.
The array formula =COUNTIF(C5:C29,"C")
counts the value of colomn C.
What adjustment do I need to do to include the values in colomn D?
I tried this: =COUNTIF(C5:C29,"C"), (D529,"M")
but had an error
Khalil
I had this before, but it didn't work weel! I may have not made it clear.
Range C5:C29 containes either letter C or letter M.
Range D529 containes either letter M or letter F
line 5 C F
line 6 C M
line 7 M M
...........
In cell D34 I want to count the number of occurance of the combination of C
and M.
The array formula =COUNTIF(C5:C29,"C")
counts the value of colomn C.
What adjustment do I need to do to include the values in colomn D?
I tried this: =COUNTIF(C5:C29,"C"), (D529,"M")
but had an error
Khalil