View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default 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