SUMIFS with three criteria & a >

[eobrien]

Hello Friends,

I'm stumped. I want to pull negative amounts only from multiple lines. For a specific name, and specific account number. Not sure if I need a sumproduct or two different formulas to get the result I need. I know this should be simple, but I'm just not getting it today. Any help please & thank you. E.

Valid formula wrong result
=-(SUMIFS(Qkbks!$H$6:$H$272,Qkbks!$G$6:$G$272,"Providers:Bangar",Qkbks!$F$6:$F$272,"1170")<"0")

Too many arguments
=-SUMIFS(Qkbks!$H$6:$H$272,"<0",Qkbks!$G$6:$G$272,"Providers:Bangar",Qkbks!$F$6:$F$272,"1170")

 

[Fluff]

How about

=-SUMIFS(Qkbks!$H$6:$H$272,Qkbks!$H$6:$H$272,"<0",Qkbks!$G$6:$G$272,"Providers:Bangar",Qkbks!$F$6:$F$272,"1170")

 

[eobrien]

How about

=-SUMIFS(Qkbks!$H$6:$H$272,Qkbks!$H$6:$H$272,"<0",Qkbks!$G$6:$G$272,"Providers:Bangar",Qkbks!$F$6:$F$272,"1170")

Result is 0 with your formula. Not the -195.00

 

[Fluff]

Looks like you might have had a typo in your original formula. Should the last criteria be 1170 or 1107?

 

[eobrien]

That was it! Urgh! Makes me so mad when I make stupid mistakes like that. Thank you. I appreciate your help! Have a great evening. E.

 

[Fluff]

You're welcome & thanks for the feedback.