| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need an autosum for each box where employees use x's of 1's
I need a way in Excel 2003 to calculate marks in each box versus numbers,
(i.e., xxxxxxx and Excel would automatically enter 7 in the box). I need this to recaulculate itself each time another mark is added so I can keep running totals. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need an autosum for each box where employees use x's of 1's
maybe...
=len(a1) if only X's were in A1. =len(a1)-len(substitute(a1,"x","")) to count just the x's in A1 JMar wrote: I need a way in Excel 2003 to calculate marks in each box versus numbers, (i.e., xxxxxxx and Excel would automatically enter 7 in the box). I need this to recaulculate itself each time another mark is added so I can keep running totals. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scheduling employees by dates... LOOKUP or FILTER? | Excel Worksheet Functions | |||
| Array formula returning terminated employees | Excel Worksheet Functions | |||
| Number of employees in the appropriate time column | Excel Worksheet Functions | |||
| List employees with hours worked, weekly, quarterly, and annually | New Users to Excel | |||
| autosum problems | Excel Worksheet Functions | |||
Hybrid Mode
