Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Count if
how do I write a count if formula to could a range of cells that can have any
data. For example if I want to count cell a1:a6 only if the cells have some kind of data (numbers, letters, words, etc...)? Thanks for the help. |
#2
|
|||
|
|||
=COUNTA(A1:A6)
Jim wrote: how do I write a count if formula to could a range of cells that can have any data. For example if I want to count cell a1:a6 only if the cells have some kind of data (numbers, letters, words, etc...)? Thanks for the help. |
#3
|
|||
|
|||
Would =COUNTA(A1:A6) function help?
-- Return email address is not as DEEP as it appears "Jim" wrote in message ... how do I write a count if formula to could a range of cells that can have any data. For example if I want to count cell a1:a6 only if the cells have some kind of data (numbers, letters, words, etc...)? Thanks for the help. |
#4
|
|||
|
|||
Try in say, B1: =COUNTA(A:A)
-- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Jim" wrote in message ... how do I write a count if formula to could a range of cells that can have any data. For example if I want to count cell a1:a6 only if the cells have some kind of data (numbers, letters, words, etc...)? Thanks for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |