D David Lewis Mar 16, 2004 #1 I am doing a list and putting X like a check box for yes and a blank cell for no. How can I count how many cells have a X in it.
I am doing a list and putting X like a check box for yes and a blank cell for no. How can I count how many cells have a X in it.
J JulieD Mar 16, 2004 #2 Hi David by using the COUNTIF function - which has two parameters =COUNTIF(range to check, criteria) so if your list is in column A then you could use the following formula in say B1 =COUNTIF(A:A,"X") i assumed there that the "X" was created by clicking on the x key on your keyboard - if not, and the above doesn't work, please repost Hope this helps Cheers JulieD
Hi David by using the COUNTIF function - which has two parameters =COUNTIF(range to check, criteria) so if your list is in column A then you could use the following formula in say B1 =COUNTIF(A:A,"X") i assumed there that the "X" was created by clicking on the x key on your keyboard - if not, and the above doesn't work, please repost Hope this helps Cheers JulieD
