Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to count#cells w/= value in other column and not count blank c | Excel Worksheet Functions | |||
Count non-blank cells? | Excel Discussion (Misc queries) | |||
Count from Blank & Non-Blank Cells | Excel Discussion (Misc queries) | |||
Count the non blank cells | Excel Worksheet Functions | |||
COUNT ONLY CELLS THAT AREN'T BLANK | Excel Worksheet Functions |