Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
How can I make the SUMIFS more complex, to only SUM the positivenegative numbers from A2:A4 ? (AND not to include the lines with "foo" string in the B column)
How can I make the SUMIFS more complex, to only SUM the positive numbers from A2:A4 ? (AND not to include the lines with "foo" string in the B column)
How can I make the SUMIFS more complex, to only SUM the negative numbers from A2:A4 ? (AND not to include the lines with "foo" string in the B column)