ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Countif (https://www.excelbanter.com/new-users-excel/449192-countif.html)

HunorR August 22nd 13 08:25 AM

Countif
 
Hello,

I need a little help whit my project.I have multiple sheets and every sheet has multiple tables. I have found the way how to count so me names in my table whit the countif syntax bat my problem is that i cant fill 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 incorrect 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 datas

Claus Busch August 22nd 13 08:53 AM

Countif
 
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

HunorR August 22nd 13 10:11 AM

Quote:

Originally Posted by Claus Busch (Post 1613556)
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



Thank you!!!


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com