Counting cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adel Handal - 09 Nov 2006 07:05 GMT

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 D5:D29 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"), (D5:D29,"M")
but had an error

Khalil

Reply to this Message

FloMM2 - 10 Nov 2006 05:56 GMT

Adel,
This is what I came up with:
Column C Column D
C or M M or F
C5 thru C29 D5 thru D29

In cell C34, this formula:
"=IF(COUNTIF(C5:C29,"c"),COUNTIF(C5:C29,"c")+COUNTIF(D5:D29,"m"),0)"
This will put a zero, if column C has no "C" in it.
HTH

> Hi,
> I had this before, but it didn't work weel! I may have not made it clear.
[quoted text clipped - 15 lines]
>
> Khalil

Reply to this Message