I need to create a function that allows me to evaluate two fields in multiple
rows and columns. So if cell A=Bob and cell B=DTY then multiply by 40 buty if
cell A=Bob and cell B=VOL then multiply by 10.

I am on a volunteer fire department and we pay several different ways for a
run. So when I record a run I put a code next to the members name based on
which way they are paid for that call. They could be on-call, volunteer,
driver, etc and each is paid differently.

I need to do this for several rows and columns. So my sheet might look like
this and I need the formula to look at all the cells and make the evaluation
and calculation and then add each total together. So I need to add all Bob's
DTY pay with his VOL pay and get the total pay.

Bob DTY Bo DTY Charles DRV Matt MMC Mike OS
Don DTY Bob DTY Charles DRV Bo OS
Don DTY Bob DTY Russ OS
Russ DTY Bob VOL Charles DRV Mike OS
Matt DTY Bob DTY Mike OS
Russ DTY Bob DTY Charles DRV


thanks