Countif

Discussion in 'Excel Beginners' started by HunorR, Aug 22, 2013.

  1. HunorR

    HunorR Guest

    Hello,

    I need a little help whit my project.I have multiple sheets and ever
    sheet has multiple tables. I have found the way how to count so me name
    in my table whit the countif syntax bat my problem is that i cant fil
    out the syntax correctly.

    Example:

    =COUNTIF('Proiectare el. mec.'!C4:AG18,A3)
    =COUNTIF('Proiectare el. mec.'!C4:AG18,A4)
    =COUNTIF('Proiectare el. mec.'!C4:AG18,A5)
    =COUNTIF('Proiectare el. mec.'!C4:AG18,A6) and this should go to A135

    Bat when i try to fill out automatically it will give me incorrec
    fields.

    Example:

    =COUNTIF('Proiectare el. mec.'!C4:AG18,A18)
    =COUNTIF('Proiectare el. mec.'!C4:AG18,A19)
    =COUNTIF('Proiectare el. mec.'!C21:AG35,A20)
    =COUNTIF('Proiectare el. mec.'!C22:AG36,A21)
    =COUNTIF('Proiectare el. mec.'!C22:AG36,A22)
    =COUNTIF('Proiectare el. mec.'!C22:AG36,A23)

    Please help me to correct this problem because i have thousands of data


    --
    HunorR
     
    HunorR, Aug 22, 2013
    #1
    1. Advertisements

  2. HunorR

    Claus Busch Guest

    Hi,

    Am Thu, 22 Aug 2013 08:25:34 +0100 schrieb HunorR:

    > =COUNTIF('Proiectare el. mec.'!C4:AG18,A3)
    > =COUNTIF('Proiectare el. mec.'!C4:AG18,A4)
    > =COUNTIF('Proiectare el. mec.'!C4:AG18,A5)
    > =COUNTIF('Proiectare el. mec.'!C4:AG18,A6) and this should go to A135


    try:
    =COUNTIF('Proiectare el. mec.'!$C$4:$AG$18,A3)



    Regards
    Claus B.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Aug 22, 2013
    #2
    1. Advertisements

  3. HunorR

    HunorR Guest

    Claus Busch;1613556 Wrote:
    > Hi,
    >
    > Am Thu, 22 Aug 2013 08:25:34 +0100 schrieb HunorR:
    > -
    > > =COUNTIF('Proiectare el. mec.'!C4:AG18,A3)
    > > =COUNTIF('Proiectare el. mec.'!C4:AG18,A4)
    > > =COUNTIF('Proiectare el. mec.'!C4:AG18,A5)
    > > =COUNTIF('Proiectare el. mec.'!C4:AG18,A6) and this should go t

    > A135-
    >
    > try:
    > =COUNTIF('Proiectare el. mec.'!$C$4:$AG$18,A3)
    >
    >
    >
    > Regards
    > Claus B.
    > --
    > Win XP PRof SP2 / Vista Ultimate SP2
    > Office 2003 SP2 /2007 Ultimate SP2




    Thank you!!


    --
    HunorR
     
    HunorR, Aug 22, 2013
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Firecraker

    Countif Question

    Firecraker, Feb 11, 2004, in forum: Excel Beginners
    Replies:
    8
    Views:
    125
    Laura Cook
    Feb 12, 2004
  2. snickstx

    COUNTIF using 2 ranges??

    snickstx, May 3, 2004, in forum: Excel Beginners
    Replies:
    3
    Views:
    104
    snickstx
    May 3, 2004
  3. cp

    countif

    cp, May 18, 2004, in forum: Excel Beginners
    Replies:
    6
    Views:
    106
    Ragdyer
    Jun 13, 2004
  4. Mattymoo

    Countif

    Mattymoo, Jul 22, 2004, in forum: Excel Beginners
    Replies:
    3
    Views:
    90
    Guest
    Jul 22, 2004
  5. bellis

    Countif help!!!

    bellis, Jul 30, 2004, in forum: Excel Beginners
    Replies:
    6
    Views:
    123
    Tom Ogilvy
    Aug 1, 2004
  6. MR

    countif if its bolded

    MR, Jul 30, 2004, in forum: Excel Beginners
    Replies:
    2
    Views:
    83
    Gord Dibben
    Jul 30, 2004
  7. Pascale

    Countif function

    Pascale, Aug 11, 2004, in forum: Excel Beginners
    Replies:
    4
    Views:
    164
    Domenic
    Aug 13, 2004
  8. Deltaecho

    CountIf Limitation?

    Deltaecho, Aug 27, 2004, in forum: Excel Beginners
    Replies:
    7
    Views:
    119
    Harlan Grove
    Aug 29, 2004
Loading...