Total 'x' in a certain column
 

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

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