Evaluating values in cells (an Array?) and returning a dollar amount

[Beth]

I have a spreadsheet with a series of cells, some with x's some without.
Depending on which cells contain an X, I'd like to return a dollar amount in
the Cost column (H). I think this should be done with Arrays, but I an a
rookie at this type of stuff. I believe I have two arrays, Type and
Category. Only one cell in each array can contain an X.

Below is a sample of how the data is currenly layed out:

A B C D E F
G H
1 Type1 Type2 Type3 Type4 Cat1 Cat2 Cat3 Cost
2 x x
?
3 x
x ?
4 x x
?
5 x x
?

Below I've described how I would evaluate the two arrays and return an
amount:
If Type1 and Cat1, Then $10
If Type1 and Cat2, Then $20
If Type1 and Cat3, Then $30
If Type2 and Cat1, Then $15
Etc....

Now I just need help in writing the formula/function.

Thanks, Beth

 

[Bob Phillips]

Think we needed a couple more examples but here is a shot

=(MATCH("X",A22,0)-1)*5+(MATCH("X",E2:G2,0)*10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)