Total 'x' in a certain column
With
A1:A1300 containing either X's or blanks
This formula counts the number of cells containing only "X"
=COUNTIF(A1:A1300,"X")
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"SLKoelker" wrote:
I have a spreadsheet with over 1300 lines and who knows how many columns. I
am trying to figure the total number of 'complete parts' in my spreadsheet. I
have a 'complete' column that I have just been putting an 'x' in when its
complete but I would be better to have a running total at the bottom for
quick reference. Is there a way to total up the x's in my 'complete' column??
Please help. Thanks
|