Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that counts cells with a specific value
Thanks a lot for the proposed solution, it works. However, what I overlooked is the fact that some of the numbers in column that should be counted have the text format. Any way to count the cells in a column that have a value(although text) except the blank cells? Thanks very much! -- VILLABILLA ------------------------------------------------------------------------ VILLABILLA's Profile: http://www.excelforum.com/member.php...fo&userid=2242 View this thread: http://www.excelforum.com/showthread...hreadid=491406 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro that counts cells with a specific value
Application.CountIf(Range("D:D"), "<0")
This will count all cells except the cells with 0 If you want to count all cells that are not blank use MsgBox Application.CountA(Range("D:D")) -- Regards Ron de Bruin http://www.rondebruin.nl "VILLABILLA" wrote in message ... Thanks a lot for the proposed solution, it works. However, what I overlooked is the fact that some of the numbers in column that should be counted have the text format. Any way to count the cells in a column that have a value(although text) except the blank cells? Thanks very much! -- VILLABILLA ------------------------------------------------------------------------ VILLABILLA's Profile: http://www.excelforum.com/member.php...fo&userid=2242 View this thread: http://www.excelforum.com/showthread...hreadid=491406 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
average daily counts to weekly counts | Excel Discussion (Misc queries) | |||
Email Macro specific Cells? | Excel Worksheet Functions | |||
Macro to only change specific cells | Excel Programming | |||
Run Macro from specific cells | Excel Programming | |||
Excel Counts Cells | Excel Discussion (Misc queries) |