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 |
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 |
Quote:
Thank you!!! |
All times are GMT +1. The time now is 11:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com