looking up 20 differnt cells to determine what value to return from the price list

[garygrewal]

Hello,
I need a formula to determine the total cost based on what cells I have check marked. Could someone help me? Thanks very much Gary

[TMS]

And how would you expect anyone to help you?

No workbook, no formula, no sample data ... What sort of check marks? Which cells do you need to sum, assuming the checkboxes are ticked?

Do you see where I'm going with this ... ? ;-)


Regards