Forum Discussion
How can i get a sum from different if conditions
Hello, First time poster and excel rookie. I wanna make a sheet where i can input a value (in this case a measurement) then i want the sheet to check whether the input is between a given range a...
If I understood you correctly, I think you need the XLOOKUP function
In this example, input in B1, test against E2:E4, then add conditional increment in G2:G4, result in B2.