Forum Discussion

Bahjat_Haddad's avatar
Bahjat_Haddad
Copper Contributor
Nov 01, 2023
Solved

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's avatar
    Harun24HR
    Nov 01, 2023

    Bahjat_Haddad Use SUMPRODUCT() function.

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

     

     

Bahjat_Haddad's avatar
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's avatar
Harun24HR
Silver Contributor
Nov 09, 2023
Then we have to use >= or <= operators.
  • Bahjat_Haddad's avatar
    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