how do i represent numbers with letters

[cfitz]

basically what i'm trying to do is this. i am using a spread sheet where the
only things i put in the cells is "x" or "/", x will equal 100 and / will
equal 50. what i want to do is on the last cell is make it where it will add
the numbers by the x's and /'s and then give me the total in number format.

[Harald Staff]

=COUNTIF(A1:B500,"x")*100+COUNTIF(A1:B500,"/")*50

HTH. Best wishes Harald

"cfitz" <[email protected]> skrev i melding
news:[email protected]...
> basically what i'm trying to do is this. i am using a spread sheet where
the
> only things i put in the cells is "x" or "/", x will equal 100 and / will
> equal 50. what i want to do is on the last cell is make it where it will
add
> the numbers by the x's and /'s and then give me the total in number
format.

[Lee]

If your data range is A1:A5 then:

=(COUNTIF(A1:A5,"/")*50)+(COUNTIF(A1:A5,"x")*100)

>-----Original Message-----
>basically what i'm trying to do is this. i am using a
spread sheet where the
>only things i put in the cells is "x" or "/", x will
equal 100 and / will
>equal 50. what i want to do is on the last cell is make
it where it will add
>the numbers by the x's and /'s and then give me the total
in number format.
>.
>

[Peo Sjoblom]

Or in one fell swoop

=SUMPRODUCT(COUNTIF(A1:B500,{"x","/"}),{100,50})


--

Regards,

Peo Sjoblom



"Harald Staff" <[email protected]> wrote in message
news:[email protected]...
> =COUNTIF(A1:B500,"x")*100+COUNTIF(A1:B500,"/")*50
>
> HTH. Best wishes Harald
>
> "cfitz" <[email protected]> skrev i melding
> news:[email protected]...
> > basically what i'm trying to do is this. i am using a spread sheet where
> the
> > only things i put in the cells is "x" or "/", x will equal 100 and /
will
> > equal 50. what i want to do is on the last cell is make it where it will
> add
> > the numbers by the x's and /'s and then give me the total in number
> format.
>
>

[Harald Staff]

Hey, this is the "newusers" newsgroup <bg>

Best wishes Harald

"Peo Sjoblom" <[email protected]> skrev i melding
news:%[email protected]...
> Or in one fell swoop
>
> =SUMPRODUCT(COUNTIF(A1:B500,{"x","/"}),{100,50})
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
>
>
> "Harald Staff" <[email protected]> wrote in message
> news:[email protected]...
> > =COUNTIF(A1:B500,"x")*100+COUNTIF(A1:B500,"/")*50
> >
> > HTH. Best wishes Harald
> >
> > "cfitz" <[email protected]> skrev i melding
> > news:[email protected]...
> > > basically what i'm trying to do is this. i am using a spread sheet
where
> > the
> > > only things i put in the cells is "x" or "/", x will equal 100 and /
> will
> > > equal 50. what i want to do is on the last cell is make it where it
will
> > add
> > > the numbers by the x's and /'s and then give me the total in number
> > format.
> >
> >
>
>

[swatsp0p]

Just a reminder:

Excel treats the backslash as the "activate menu" command (by default in Tools>Options>Transition. This needs to be changed to a different keystroke to free up the ' / ' to be used as normal keystroke.

HTH