Doubt with Somif or Somifs

[leovilla]

hello good afternoon friends, I'm in need of one more help.
I have values ​​in two sheets that can be negative or positive. I need another spreadsheet to have the result of these values, with eosin or somases.
Thanks

[popipipo]

Try this formula:

Please Login or Register  to view this content.

[leovilla]

Okay, I understand, but I need to inform in the debit/credit column, that is, when the two values ​​are negative they can be added, and when one is negative and the other deposit cannot. that's why I need a formula with two somase.

[josephteh]

Change your formula: =SUMIF(Planilha2!C3,"<0")+SUMIF(Planilha3!C3,"<0")

[leovilla]

I did this formula several times and it never matched, with yours it was perfect, thank you so much for helping me.