![]() |
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. |
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 |
All times are GMT +1. The time now is 12:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com