Count Value And Blank Cells Value.

S

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 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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
create wbook from TEMPLATE wbook 0
Macro to delete row if cells greater than certain value 1
Copy Array to Array, how to and should I? 13
Skip copying empty column where remaining rows are filled 2
leading zeros using ActiveCell.Offset().value to insert row and value 84
Optional argument as Variant not acting like number 4
count value with filter... 0

Top