Home

Is there an IF statment equivalent to SumIFS?

Highlighted
KTOGrady2345
New Contributor

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  

2 Replies
Highlighted

You may use INDEX/MATCH or VLOOKUP

Highlighted

Thank you!   I didn't know about index/match   That worked very well. 

Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Sumif help...
bvjsdfkv1690 in Excel on
3 Replies
SumIfs Help
bb94twins in Excel on
10 Replies
Excel If Functions
Mfouad2255 in Excel on
10 Replies
Help with an IF AND formula
aanaya6 in Excel on
3 Replies