"galiant" wrote in message
...
....
Also is there a way to have it evaluate numerous cells?
So lets say you have 10 rows and each row has bob in one cell and either
DTY
or VOL. I see how the formula
=if(a2="bob",if(b2="dty",40,if(b2="vol",10,0)),0) would calculate for a
single row, but can it look at a range of rows and give me a total. So if
bob
was listed in all 10 rows it would look in each make the assesment of DTY
or
VOL and Calcualte wage for each row and then add all 10 rows together?

Copy that formula down the column, and total the column.
--
David Biddulph