Counting cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Adel Handal - 09 Nov 2006 07:02 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

Biff - 09 Nov 2006 07:30 GMT

Try one of these:

=COUNTIF(C5:D29,"C")+COUNTIF(C5:D29,"M")

=SUM(COUNTIF(C5:D29,{"C,"M"}))

Biff

> 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

Adel Handal - 09 Nov 2006 07:58 GMT

Hi,
Non of the worked!
They are arrya formulas.
The firsr one counted all the M's and C's in both colomns.
To be more clear I might refrase it as follows:
need to count the number of rows that has C and M in the same line in
colomns C and colomn D

> Try one of these:
>
[quoted text clipped - 24 lines]
>>
>> Khalil

Reply to this Message

bobocat - 09 Nov 2006 08:17 GMT

=sumproduct((c5:c29="c")*(d5:d29="m"))

"Adel Handal" <adelbhandal@hotmail.com> ¼¶¼g©ó¶l¥ó·s»D:eFJAXT9AHHA.1196@TK2MSFTNGP03.phx.gbl...

> Hi,
> Non of the worked!
[quoted text clipped - 32 lines]
>>>
>>> Khalil

Reply to this Message

Adel Handal - 09 Nov 2006 10:06 GMT

Hi,
thanks a lot . it worked fine.

> =sumproduct((c5:c29="c")*(d5:d29="m"))
>
[quoted text clipped - 36 lines]
>>>>
>>>> Khalil

Reply to this Message

Rate this thread: