Sumifs to check multiple criteria in the same column

The syntax for SUMIFS is correct, so it must be a data error. Make sure there are no floating spaces after your text string data ranges. Otherwise, you may want to upload a sample workbook that recreates your results.

Originally Posted by mcmahobt

The syntax for SUMIFS is correct, so it must be a data error.

=SUMIFS(D13:D23,B13:B23,"Sysco",B13:B23,"Euro Imports",B13:B23,"LAF")

3 criteria all using the same criteria range.

Try it like this...

=SUM(SUMIF(B13:B23,{"Sysco","Euro Imports","LAF"},D13:D23))

Your current formula will always return zero because SUMIFS works like AND - all conditions need to be true for a row for that row's value to be included......and it isn't possible for a single cell to be equal to all 3 of your text values at once - for your needs try this version which works like OR

=SUM(SUMIFS(D13:D23,B13:B23,{"Sysco","Euro Imports","LAF"}))

I quit life for today. Good call Tony.

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

If I understand what you're asking...

You can only have 1 formula in 1 cell.

If you have 2 cells for results then you need 2 formulas, 1 for each cell.