For the amount of conditions you have, you'll need to use the SUMPRODUCT
function. However, without examples of your data, or more detail, I'm afraid
I'm not sure what exact structure you need. Perhaps something like
=SUMPRODUCT((ProductRange="toaster")*(SeverityRang e="Severitylookingfor")*(EstimatedHoursRange)*(Def ectCountRange))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sri Harsha" wrote:

I am preparing an estimates tool. I have 5 different products and each has 2
types of deliverables, RN and UG.
In a table we have estimates for each product individually.
Now, i am looking for a formula which has to first see the product, then the
severity of the defect, lookup the estimated hours and multiply the no. of
defects/pages with the estimates and give. Any suggestion?