Sumifs or Countifs
Drew Cooper
✭✭✭✭
Trying to figure out the formula to solve for the following:
If Column A = "Bob" or "Frank" , and if Column B = "Blue" , then count Column C's #.
Basically trying to figure out how many blues Bob and Frank have based on the Qty in Column C. I need to exclude everything that doesn't meet those requirements.
Example:
Column A
Bob
Frank
Sarah
Column B
Blue
Red
Green
Column C
Qty
Answers

Try (Edited, after pasted it left something out):
=SUMIFS([Column C]:[Column C], [Column A]:[Column A], OR(@cell = "Bob", @cell = "Frank"), [Column B]:[Column B], "Blue")

Thanks Nic!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!