Count Value And Blank Cells Value.
 

http://www8.rapidupload.com/d.php?file=dl&filepath=886

I would want with a macro with 2 condition:
1)
Count into column A of RATE how many code are present refered th
column into sheet TABELLA
Example:

count all value with code "4500" into column A of sheet RATE and inser
the total value foud into range I2 of TABELLA (in this case I2= 66)

count all value with code "4501" into column A of sheet RATE and inser
the total value foud into range I3 of TABELLA (in this case I3=7)
....
ecc...

2)
count how many line with code 4500 (in column A) contain a value int
range AB of sheet RATE and put into J2 of TABELLA the total (in thi
case are only 5 cells filled, J2=5)

count how many line with code 4501 (in column A) contain a value int
range AB of sheet RATE and put into J3 of TABELLA the total (in thi
case are only 7 cells filled, J3=7)
.....
ecc..

--
sal2

-----------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...nfo&userid=204
View this thread: http://www.excelforum.com/showthread.php?threadid=48867