Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count value in column and VBA
Hi all:
I hope you can help with the following: How do I write a macro that would count the number of cells in column (column 19) that has a "NO" then I want excel to go to the last row and insert "Total count" i column R and the # of cells with a "NO" in column S, Is it possible to do this with a macro? thanks for helping Richard -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count value in column and VBA
This should do it.
Sub test() Dim i As Long i = Range("S65536").End(xlUp).Row Range("R" & i + 1).Value = "Total count" Range("S" & i + 1).Value Application.WorksheetFunction.CountIf(Range("S1:S" & i), "=No") End Sub -- Message posted from http://www.ExcelForum.com |
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 Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions |