Need help to choose the right function.

Hi, Can someone please advise how to get around this. I have two inputs as shown in the attached photo, in red and green. What kind of function that would return a value i.e. orifice size, from t...

Formulas and Functions

Harun24HR
Nov 01, 2023
Bahjat_Haddad Use SUMPRODUCT() function.
=SUMPRODUCT((A2:A4)*(B2:D4=C9)*(B1:D1=C8))

Harun24HR

Silver Contributor

Nov 01, 2023

Bahjat_Haddad Use SUMPRODUCT() function.

=SUMPRODUCT((A2:A4)*(B2:D4=C9)*(B1:D1=C8))

Bahjat_Haddad
Copper Contributor
Nov 08, 2023
Harun24HR One more question please, if the value in cell C9 is 7 instead of 9, how can I write the equation so it can go automatically to the next higher value i.e. 9?
- Harun24HR
  Silver Contributor
  Nov 09, 2023
  Then we have to use >= or <= operators.
  - Bahjat_Haddad
    Copper Contributor
    Nov 12, 2023
    I actually had tried before posting my question but didn't work for me, always showed zero. Could you please demonstrate? Thanks
Bahjat_Haddad
Copper Contributor
Nov 02, 2023
Harun24HR Thanks a lot
- Harun24HR
  Silver Contributor
  Nov 02, 2023
  If you find it useful then please tick mark it as best response.

Forum Discussion

Need help to choose the right function.