High = 4
 

Someone help! I need to know how I would do this i want to creat a formula
so that when i type in High it will equal 4 or Medium equal 2 or low equal 1.
So for example:

= IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add
highs, mediums and lows on the spreadsheet and then give me a total in number.

High = 4
 

One way:

=4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium") + COUNTIF(A:A,"Low")

In article ,
Formulas wrote:

Someone help! I need to know how I would do this i want to creat a formula
so that when i type in High it will equal 4 or Medium equal 2 or low equal 1.
So for example:

= IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add
highs, mediums and lows on the spreadsheet and then give me a total in number.

High = 4
 

Another way...

=MATCH(A1,{"Low","Medium","`","High"},0)

Rick


"Formulas" wrote in message
...
Someone help! I need to know how I would do this i want to creat a
formula
so that when i type in High it will equal 4 or Medium equal 2 or low equal
1.
So for example:

= IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add
highs, mediums and lows on the spreadsheet and then give me a total in
number.

High = 4
 

JE McGimpsey wrote...
One way:

=4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium")
+ COUNTIF(A:A,"Low")
....

Variation,

=SUMPRODUCT(COUNTIF(A:A,{"High";"Medium";"Low"}),{ 4;2;1})

High = 4
 

Hi,

I think this will work but i wouldn't know where to start it in the
spreadsheet?

Thanks,

"JE McGimpsey" wrote:

One way:

=4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium") + COUNTIF(A:A,"Low")

In article ,
Formulas wrote:

Someone help! I need to know how I would do this i want to creat a formula
so that when i type in High it will equal 4 or Medium equal 2 or low equal 1.
So for example:

= IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add
highs, mediums and lows on the spreadsheet and then give me a total in number.

High = 4
 

Hi,

I think this will work but i wouldn't know where to start it in the
spreadsheet?

Thanks,

"Harlan Grove" wrote:

JE McGimpsey wrote...
One way:

=4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium")
+ COUNTIF(A:A,"Low")
....

Variation,

=SUMPRODUCT(COUNTIF(A:A,{"High";"Medium";"Low"}),{ 4;2;1})

High = 4
 

Hi,

Can i send you the part of the spreadsheet i am trying to do? The formula
seems like it will work but i am not to sure how to use it.

Thanks,

"JE McGimpsey" wrote:

One way:

=4*COUNTIF(A:A,"High") + 2*COUNTIF(A:A,"Medium") + COUNTIF(A:A,"Low")

In article ,
Formulas wrote:

Someone help! I need to know how I would do this i want to creat a formula
so that when i type in High it will equal 4 or Medium equal 2 or low equal 1.
So for example:

= IF(4,High;2, Medium;1,Low=()) - This doesnt work What i want is to add
highs, mediums and lows on the spreadsheet and then give me a total in number.

High = 4
 

Sending the workbook isn't really necessary - and my filters would kill
your message anyway.

Just enter the formula in a cell, changing "A:A" to the range you're
interested in.

In article ,
High = 4 take 2 wrote:

Can i send you the part of the spreadsheet i am trying to do? The formula
seems like it will work but i am not to sure how to use it.