Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I use the following formula to mark an "X" in a column of cell when there is content in a series of other cells. What formula do I se to count the "X?" What I'm using now counts the furmula entry. Thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Let's say that column A has X's in some cells and blanks in other cells
=COUNTIF(A:A,"X") should give you what you need -- Gary''s Student - gsnu200822 "Jim" wrote: Hello, I use the following formula to mark an "X" in a column of cell when there is content in a series of other cells. What formula do I se to count the "X?" What I'm using now counts the furmula entry. Thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
=COUNTIF(D:D,"x") where I have assumed column D is used for your Xs. Hope this helps. Pete On Dec 31, 2:22*pm, Jim wrote: Hello, I use the following formula to mark an "X" in a column of cell when there is content in a series of other cells. What formula do I se to count the "X?" *What I'm using now counts the furmula entry. Thanks |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Perfect - Thanks
"Gary''s Student" wrote: Let's say that column A has X's in some cells and blanks in other cells =COUNTIF(A:A,"X") should give you what you need -- Gary''s Student - gsnu200822 "Jim" wrote: Hello, I use the following formula to mark an "X" in a column of cell when there is content in a series of other cells. What formula do I se to count the "X?" What I'm using now counts the furmula entry. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count number of cells and total in one column, based on another column suffix | 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 | |||
SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions |