Hello All, I am wondering if there's a formula I could use like a sumifs that would add all the data even if a particular criteria is not found in the range.

Example:

=SUMIFS($O$1:$O$16,$N$1:$N$16,"Yes",$M$1:$M$16,"Yes",$L$1:$L$16,"Yes")

The above would sum all the numbers if columns N,M,L contain "Yes" in them, but what if column M doesn't contain "Yes" I would like the sum of columns N and L still. Is there a formula to make this happen? any help would be appreciated.