Hi,

Please find the attached excel sheet..Please note i have removed all other columns since it was confidential data :) The 1st tab has the data on which i want to operate and at the bottom of the 1st tab i have tried to use the formula u mentioned but getting value error for say priority=high/critical. In "sheet2" tab I tried to use the same data columns and formula and it works fine !!!!! In the summary tab i have tried to the same formulas but in different sheet and tried to provide references to the data in 1st tab.

-Thanks
Ram