Forum Discussion

KTOGrady2345's avatar
KTOGrady2345
Copper Contributor
Jan 19, 2019

Is there an IF statment equivalent to SumIFS?

I have a spreadsheet with a tab that has my data in a database format.    I need to write an if statement that will search a column of data and return a value from a different cell within the same record line.  (Search a list of products and return the price)

 

I have used the Countifs and  Sumifs formulas in the same database and am receiving good totals.   however I don't see an equivalent for IF  

Resources