Thread: Countif
View Single Post
  #2   Report Post  
Old August 22nd 13, 08:53 AM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,872
Default Countif


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

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

Claus B.
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2