| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mileage Claim Formula | New Users to Excel | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
Linear Mode
