Is SUMIFS broken ?

SUMIFS function does not work when you to try to total the sales across multiple columns.

However, SUMIF Function works.

Strange. Don't believe me, try it yourself.

There is a new way to resolve this issue. It can be easily done using FILTER function in conjunction with Sum Function.

By using FILTER function, it will result into an array of output based on the condition that can be wrapped within sum function to give the end result.

Please don't forget to subscribe.