Formula with multiple criteria

[Manny Singh]

Hi All,

I am a new user and very excited to be part of this forum, I will appreciate if some of you Excel Gurus could help me with below:

Referring to attached file, I have a table that shows "A no." for 6 chemical parts, single values are maximum and some cells have got range.

At the bottom of table, I need to write a formula that can calculate A no. for 6 inputs.

I tried Nested If and my head started spinning after few minutes so I am hoping some ninja can help.

Thanks,
Manny

 

[NARAYANK991]

Hi ,

See if this is correct.

Narayan

 

[Manny Singh]

Hi Narayan,

You truly are excel Ninja, thanks a lot, I got to learn some new tricks.

 

[bines53]

Hi ,

A formula with a function MID,
Concluding formula ,
=MATCH(6,MMULT(--(K3 : P14=1),{1;1;1;1;1;1}),0)

David

 

[Manny Singh]

Thanks David, it will take me a lot of time to properly understand the formula, but thanks for taking time.

 

[bines53]

I hope it will happen soon