How to add (sum) a row cells with letter

"Max" wrote:

> Unable to download your sample as per the link given
>
> Try using the earlier simple, free filehost to upload:
> http://www.freefilehosting.net/
>
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> Downloads:17,400 Files:358 Subscribers:55
> xdemechanik
> ---
> "JC-PS" <JCPS.TakeThisOut@discussions.microsoft.com> wrote >>
> >> This is a portion of the table pasted I'm working on, I hope may be
> >> lightful.
> >
> > http://www.megaupload.com/es/?d=UPZXUDGR
>
>
> Try this time, I've been using the language version for the others pads. This time should work out well or better...

http://www.megaupload.com/?d=UPZXUDGR

Sorry, am unable to proceed. Suggest that you start a new thread for your
new query. Note that it is always easier not to mix numbers with letters, as
has been mentioned by others.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,400 Files:358 Subscribers:55
xdemechanik
---

"Héctor Miguel" wrote:

> hi, !
>
> > I'm trying to add cells WITH numbers but they have letters (alphanumerical).
> > Example: A B C D E Total of sick days (S) Total vacations (L)
> > L2.3 S3 W L3.3 - ..... 3 5.5
> > L1.2 - - - - 1.2
> > I'd like to sum just numbers of previous cells of A to E and total them at the last columns.
>
> sick days: =sum(if(left(a2:e2,1)="s",--mid(a2:e2,2,10)))
> vacations: =sum(if(left(a2:e2,1)="l",--mid(a2:e2,2,10)))
>
> > ... if conditional formula may concider like the W letter but with a specific value like 7.2 and add it to a previos total.
>
> (i.e.) =countif(a2:e2,"w")*7.2
>
> > The same for S and L.
>
> try with something like above and...
>
> if any doubt (or further information)... would you please comment ?
> regards,
> hector.
>
>
> The formula =SUM(IF(LEFT(C51:N51,1)="s",--MID(C51:N51,2,10)))=COUNTIF(A2:E2,"s")*7.2 shows #VALUE! with CSE or without =countif...
The other one;
=SUM(IF(LEFT(A1:D1)="S",IF(ISNUMBER(--MID(A1:D1,2,10)),--MID(A1:D1,2,10))))
enter with CSE shows or add only S with numbers, but no just the S alone
which must be included in the formula for the value of 7.5.
If I have in the 2 Row, S3.5 in A2, and S in C2, and other letter meaning
for vacation "L" in E2, it should end up counting just the S including those
alphanumerical and exclude other letters. So the result must be 11. I hope
this time I expressed it better.

"JC-PS" wrote:

>
>
> "Héctor Miguel" wrote:
>
> > hi, !
> >
> > > I'm trying to add cells WITH numbers but they have letters (alphanumerical).
> > > Example: A B C D E Total of sick days (S) Total vacations (L)
> > > L2.3 S3 W L3.3 - ..... 3 5.5
> > > L1.2 - - - - 1.2
> > > I'd like to sum just numbers of previous cells of A to E and total them at the last columns.
> >
> > sick days: =sum(if(left(a2:e2,1)="s",--mid(a2:e2,2,10)))
> > vacations: =sum(if(left(a2:e2,1)="l",--mid(a2:e2,2,10)))
> >
> > > ... if conditional formula may concider like the W letter but with a specific value like 7.2 and add it to a previos total.
> >
> > (i.e.) =countif(a2:e2,"w")*7.2
> >
> > > The same for S and L.
> >
> > try with something like above and...
> >
> > if any doubt (or further information)... would you please comment ?
> > regards,
> > hector.
> >
> >
> > The formula =SUM(IF(LEFT(C51:N51,1)="s",--MID(C51:N51,2,10)))=COUNTIF(A2:E2,"s")*7.2 shows #VALUE! with CSE or without =countif...
> The other one;
> =SUM(IF(LEFT(A1:D1)="S",IF(ISNUMBER(--MID(A1:D1,2,10)),--MID(A1:D1,2,10))))
> enter with CSE shows or add only S with numbers, but no just the S alone
> which must be included in the formula for the value of 7.5.
> If I have in the 2 Row, S3.5 in A2, and S in C2, and other letter meaning
> for vacation "L" in E2, it should end up counting just the S including those
> alphanumerical and exclude other letters. So the result must be 11. I hope
> this time I expressed it better.
>>>>>
>>>>>I posted the table I'm trying to finished hardly so far, and you
>>>>>may see it on:
>>>>>http://www.megaupload.com/?d=2ZI47CUS.
>>>>>I hope might be helpful illustrated with laterals explanations and questions.