Re: Converting Text into a Numeric Value and Totalling
- From: "Nick" <nick@xxxxxxxxxxxx>
- Date: Tue, 10 May 2005 17:14:54 +0100
If you are only using H and HH then you could use the following formula.
Values entered in Range A1:A8
=(COUNTIF(A1:A8,"H")*1)+(COUNTIF(A1:A8,"HH")*0.5)
If you are using lots of different characters to represent values then you
would need something a little more complex.
Hope this helps.
Nick
"Shazbut" <Shazbut.1oto5o@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:Shazbut.1oto5o@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> I am currently working on a spreadsheet whereby I want to automatically
> total entries made in text.
>
> I am fine using "countif" for most of my codes but I have a problem.
>
> I have a code of "H" which is equal to 1 and a code of "HH" which is
> equal to 0.5.
>
> I want to know if it is possible to enter a formula that will total the
> amount of "H"s (H=1) AND the total of "HH"s (HH=0.5) within the same
> formula.
>
> E.G. The spreadsheet contains 5 cells with "H" entered and 3 cells
> with "HH" entered. Therefore the total should be 6.5.
>
> Is such a formula possible?
>
>
> --
> Shazbut
.
- References:
- Converting Text into a Numeric Value and Totalling
- From: Shazbut
- Converting Text into a Numeric Value and Totalling
- Prev by Date: How do I make labels from excel spreedsheet?
- Next by Date: How do you toggle back and forth between worksheets in Excel?
- Previous by thread: Converting Text into a Numeric Value and Totalling
- Next by thread: freezing cell values
- Index(es):
Relevant Pages
|
