COUNTIFS and SUMIFS Help

[jmattingly85]

I am attempting to complete SUMIFS and COUNTIFS and am not getting any results. A sample formula I am using is:

=COUNTIFS('Tracking Sheet'!$H:$H,"2016",'Tracking Sheet'!$D:$D,"Repaid",'Tracking Sheet'!$D:$D,"Closed")

If I break the formula apart and only have two arguments, I get a result.

I am assuming it is because the formula is looking for two different values in the same column, but I am not sure. Any suggestions?

Thank you in advance!

 

[Marcelo Branco]

Maybe...

=SUM(COUNTIFS('Tracking Sheet'!$H:$H,"2016",'Tracking Sheet'!$D:$D,{"Repaid","Closed"}))

M.