PDA

View Full Version : COUNT VALUE AND BLANK CELLS VALUE



sal21
11-28-2005, 04:45 AM
http://www8.rapidupload.com/d.php?file=dl&filepath=886 (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...

Bob Phillips
11-28-2005, 08:02 AM
i2: =COUNTIF(RATE!A:A,A2)
J2: =SUMPRODUCT(--(RATE!$A$3:$A$2500=A2),--(RATE!$AB$3:$AB$2500<>""))