Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I get the letters A & S to add 1 in excel
I have a spread sheet for members in the colum that adds the attendences up
is there a way of that I can get it to add an A as 1 & an S as 2 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I get the letters A & S to add 1 in excel
Hi
assuming that you're not doing this in code and are looking for a worksheet function, something along the lines of a COUNTIF might work. =COUNTIF(A1:A100,"A") counts the number of A's in the range A1:A100 or =COUNTIF(A1:A100,"S")*2 counts the number of S's in the range A1:A100 and multiples the answer by 2 so =COUNTIF(A1:A100,"A")+COUNTIF(A1:A100,"S")*2 will probably give you what you're looking for Hope this helps Cheers JulieD "johnboy46" wrote in message ... I have a spread sheet for members in the colum that adds the attendences up is there a way of that I can get it to add an A as 1 & an S as 2 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I get the letters A & S to add 1 in excel
Of course you can't add letters but maybe
=if(a3="A",1,if(a3="s",2,"")) or use the COUNTIF function. Look in HELP index -- Don Guillett SalesAid Software "johnboy46" wrote in message ... I have a spread sheet for members in the colum that adds the attendences up is there a way of that I can get it to add an A as 1 & an S as 2 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I get the letters A & S to add 1 in excel
THANK YOU done the trick spot on .Ive tryed for 2 weeks to get it right you
done it in 5 min Johnboy46 "JulieD" wrote: Hi assuming that you're not doing this in code and are looking for a worksheet function, something along the lines of a COUNTIF might work. =COUNTIF(A1:A100,"A") counts the number of A's in the range A1:A100 or =COUNTIF(A1:A100,"S")*2 counts the number of S's in the range A1:A100 and multiples the answer by 2 so =COUNTIF(A1:A100,"A")+COUNTIF(A1:A100,"S")*2 will probably give you what you're looking for Hope this helps Cheers JulieD "johnboy46" wrote in message ... I have a spread sheet for members in the colum that adds the attendences up is there a way of that I can get it to add an A as 1 & an S as 2 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can I get the letters A & S to add 1 in excel
you're welcome ... when i'm teaching - my advice to my students is that if
you struggle to get a solution for more than 30 mins then go check out the newsgroups (but do try first) ... i learnt this the hard way too :) Cheers JulieD "johnboy46" wrote in message ... THANK YOU done the trick spot on .Ive tryed for 2 weeks to get it right you done it in 5 min Johnboy46 "JulieD" wrote: Hi assuming that you're not doing this in code and are looking for a worksheet function, something along the lines of a COUNTIF might work. =COUNTIF(A1:A100,"A") counts the number of A's in the range A1:A100 or =COUNTIF(A1:A100,"S")*2 counts the number of S's in the range A1:A100 and multiples the answer by 2 so =COUNTIF(A1:A100,"A")+COUNTIF(A1:A100,"S")*2 will probably give you what you're looking for Hope this helps Cheers JulieD "johnboy46" wrote in message ... I have a spread sheet for members in the colum that adds the attendences up is there a way of that I can get it to add an A as 1 & an S as 2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Formating Letters to Numbers while Displaying Letters | Excel Worksheet Functions | |||
Columns now numbers rather than letters how do i get letters back | Excel Discussion (Misc queries) | |||
Remove dashes between letters and between letters and digits | Excel Worksheet Functions | |||
How do change a column of data in capitol letters to small letters | Excel Discussion (Misc queries) | |||
My Excel cols have #s, not letters. How get letters? | Excel Worksheet Functions |