Skip to main content
edited body
Source Link

enter image description here

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)

enter image description here

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)

enter image description here

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)

added 69 characters in body
Source Link

enter image description here

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)

enter image description here

How can I make the SUMIFS more complex, to only SUM the positive numbers from A2:A4 ?

enter image description here

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)

Source Link

SUMIFS with "AND" not "OR"

enter image description here

How can I make the SUMIFS more complex, to only SUM the positive numbers from A2:A4 ?