SUMIFS not working

[sharon9999]

Hi

Please can you help.
I have the formula =COUNTIFS(Sheet1!G:G,"<0",Sheet1!D:D,"BAC"), it counts the negative values in column G that refer to "BAC", however I would like to sum the negative, so tried replacing the COUNTIFS with SUMIFS, but its not working.

Thanks in advance...


Regards

SC

 

[Tetra201]

Try

=SUMIFS(Sheet1!G:G,Sheet1!G:G,"<0",Sheet1!D:D,"BAC")

 

[Scott T]

Did you add the sum range when you changed to sumifs?
Sumifs(Sumrange,criteria range1,criteria1,criteria range2,criteria2)

 

[sharon9999]

Works perfect! Thank you so much!

 

[MrOnly]

what one solved the question?

Works perfect! Thank you so much!

 

[sharon9999]

Tetra201!