Sumif only checked positive/negative values

Try this:

The formula in B7 (I've defined row 7 as a Footer Row to make it convenient to put a formula there):

=SUMIFS(B,A,TRUE,B,"<0")

For positive numbers change the "<0" to ">0"

Use ; instead of , in the formulas if your region uses , as a decimal separator.

SG

Hello,

You could use the function SUM.IFS which allows you to specify multiple conditions: SUMIFS - Apple Support. In your case, you would have 2 conditions: one on column A, the other on column B.