Hi Everyone,

Thanks for taking the time to reply to my post. I'm going to guess that
since all three of you answered by pointing me toward SUMPRODUCT rather than
using OR with SUMIFS that in fact one cannot use OR with SUMIFS.

Thanks.

"Ted M H" wrote:

I have a table with columns Product, Units Sold, Sales manager.
Products values are A, B, C, D, E, F
Units sold is a simple integer
Sales manager values are Smith, Jones, Doe
Can I use SUMIFS to return the total units sold if manager name is Smith AND
Product is A, OR manager name is Smith and Product is B.

I tried to use OR in the second criteria argument, but cant get it to work.
I know there are other ways to solve this problem, but Im trying
specifically to understand what SUMIFS can and cant do.
Thanks.