Forum Discussion
KTOGrady2345
Jan 19, 2019Copper Contributor
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
You may use INDEX/MATCH or VLOOKUP
- KTOGrady2345Copper Contributor
Thank you! I didn't know about index/match That worked very well.