ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I need an autosum for each box where employees use x's of 1's (https://www.excelbanter.com/excel-worksheet-functions/70173-i-need-autosum-each-box-where-employees-use-xs-1s.html)

JMar

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.

Dave Peterson

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