| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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  29 containes either letter M or letter Fline 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 29,"M")but had an error Khalil |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Try one of these:
=COUNTIF(C5 29,"C")+COUNTIF(C529,"M")=SUM(COUNTIF(C5 29,{"C,"M"}))Biff "Adel Handal" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 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 29 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 29,"M")> but had an error > > Khalil > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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 "Biff" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > Try one of these: > > =COUNTIF(C5 29,"C")+COUNTIF(C529,"M")> > =SUM(COUNTIF(C5 29,{"C,"M"}))> > Biff > > "Adel Handal" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >> 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 29 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 29,"M")>> but had an error >> >> Khalil >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
=sumproduct((c5:c29="c")*(d5:d29="m"))
"Adel Handal" <(E-Mail Removed)> 撰寫於郵件新聞:(E-Mail Removed)... > 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 > > > "Biff" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... >> Try one of these: >> >> =COUNTIF(C5 29,"C")+COUNTIF(C529,"M")>> >> =SUM(COUNTIF(C5 29,{"C,"M"}))>> >> Biff >> >> "Adel Handal" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>> 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 29 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 29,"M")>>> but had an error >>> >>> Khalil >>> >>> >> >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Hi,
thanks a lot . it worked fine. "bobocat" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > =sumproduct((c5:c29="c")*(d5:d29="m")) > > "Adel Handal" <(E-Mail Removed)> > 撰寫於郵件新聞:(E-Mail Removed)... >> 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 >> >> >> "Biff" <(E-Mail Removed)> wrote in message >> news:(E-Mail Removed)... >>> Try one of these: >>> >>> =COUNTIF(C5 29,"C")+COUNTIF(C529,"M")>>> >>> =SUM(COUNTIF(C5 29,{"C,"M"}))>>> >>> Biff >>> >>> "Adel Handal" <(E-Mail Removed)> wrote in message >>> news:(E-Mail Removed)... >>>> 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 29 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 29,"M")>>>> but had an error >>>> >>>> Khalil >>>> >>>> >>> >>> >> >> > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| counting highlighted cells or font color cells | Tired Dan | Microsoft Excel Discussion | 0 | 10th Dec 2007 11:50 PM |
| counting highlighted cells or font color cells | Tired Dan | Microsoft Excel Discussion | 0 | 10th Dec 2007 11:41 PM |
| Complicated counting of cells (based on other cells contents) | =?Utf-8?B?R2Vvcmdl?= | Microsoft Excel Worksheet Functions | 3 | 7th Nov 2005 07:39 PM |
| counting specific figures in cells dependant upon contents of adjacent cells | judoist | Microsoft Excel Discussion | 2 | 15th Jun 2004 03:45 PM |
| Counting Number of Cells Including Merged Cells | Daniel D. | Microsoft Excel Worksheet Functions | 12 | 24th Feb 2004 02:27 AM |
