instead of doing something like this:
=SUMIFS(W24:W9999,Z24:Z9999,">0",M24:M9999,">0")+SUMIFS(W24:W9999,Z24:Z9999,">0",N24:N9999,">0")-SUMIFS(W24:W9999,M24:M9999,">0",N24:N9999,">0",Z24:Z9999,">0")
is there a way to insert an "or" so the funtcion would look something like:
=sumifs(W24:W9999,Z24:Z9999,">0",M24:M9999,">0" OR N24:N9999,">0")
i know there is... i just can't find it... and searching for "or" on the message board or online help returns too many hits...
thanks for the help!
=SUMIFS(W24:W9999,Z24:Z9999,">0",M24:M9999,">0")+SUMIFS(W24:W9999,Z24:Z9999,">0",N24:N9999,">0")-SUMIFS(W24:W9999,M24:M9999,">0",N24:N9999,">0",Z24:Z9999,">0")
is there a way to insert an "or" so the funtcion would look something like:
=sumifs(W24:W9999,Z24:Z9999,">0",M24:M9999,">0" OR N24:N9999,">0")
i know there is... i just can't find it... and searching for "or" on the message board or online help returns too many hits...
thanks for the help!