COUNT VALUE AND BLANK CELLS

[sal21]

--------------------------------------------------------------------------------

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 the column into sheet TABELLA
Example:

count all value with code "4500" into column A of sheet RATE and insert 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 insert 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 into range AB of sheet RATE and put into J2 of TABELLA the total (in this case are only 5 cells filled, J2=5)

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

 

[BrianB]

I think the =COUNTIF() worksheet function will do what you want.