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

Nic Larsen

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")

Drew Cooper

Thanks Nic!!