Array Formula Help 1

[CandyS]

I need to create an array formula to do the following:

The formula will be in cell A2, and the range is named "ST" (to simplify "site type&quot

I need the formula to read the range and multiply the occurences of the site types by their respective rates, and sum:

For example:
Branch =100
NonMetro =200
Metro =300

I need the formula to basically read:
=SUM(count of "Branch" in Range ST X 100) + (count of "NonMetro" in Range ST X 200) + (count of "Metro" X 300)

I can do conditional counts in an array, but multiple conditions are beyond my capability.

Thanks!

Candy

 

[xlbo]

no need for an array
=(countif(ST,"Branch&quot*100)+(countif(ST,"NonMetro&quot*200)+(countif(ST,"Metro&quot*300)

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[CandyS]

xlbo: It works! Thanks so much for your valuable help!

Regards,

Candy