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

    Bahjat_Haddad Use SUMPRODUCT() function.

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