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

  1. HunorR

    HunorR Guest


    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.


    =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


    =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, Aug 22, 2013
    1. Advertisements

  2. HunorR

    Claus Busch Guest


    Am Thu, 22 Aug 2013 08:25:34 +0100 schrieb HunorR:
    =COUNTIF('Proiectare el. mec.'!$C$4:$AG$18,A3)

    Claus B.
    Claus Busch, Aug 22, 2013
    1. Advertisements

  3. HunorR

    HunorR Guest

    Thank you!!
    HunorR, Aug 22, 2013
    1. Advertisements

Ask a Question

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.