Thread: High = 4
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
  
Posts: 733
Default 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})

Reply With QuoteReply With Quote