Hi - How do I write a count formula for non-blank cells that may contain either a "X" or a number?
M Mrebisz3154 Jan 18, 2006 #1 Hi - How do I write a count formula for non-blank cells that may contain either a "X" or a number?
R Ron Coderre Jan 18, 2006 #2 See if the COUNTA function returns what you are looking for. Does that help? *********** Regards, Ron XL2002, WinXP-Pro
See if the COUNTA function returns what you are looking for. Does that help? *********** Regards, Ron XL2002, WinXP-Pro
S SteveG Jan 18, 2006 #3 =COUNTIF(A1:A30,"x")+COUNTIF(A1:A30,">=0") This is assuming you want to count cells that contain a 0, if you don't, just remove the = from the second COUNTIF. HTH Steve
=COUNTIF(A1:A30,"x")+COUNTIF(A1:A30,">=0") This is assuming you want to count cells that contain a 0, if you don't, just remove the = from the second COUNTIF. HTH Steve
