Sumifs issue with formula

Interestingly, if I change the <N/A> to something else in both the data tab and the summary cell G2 the formula returns what you want and expect.
I tried to see if the values in col L were actually negative and they were and if the <N/A> in col Z matched (no add'l spaces) the <N/A> in the data tab and it did.
if you make either of these changes it will work...=SUMIFS(Data!$L:$L,Data!$Z:$Z,"="&"<N/A>")
or =SUMIFS(Data!$L:$L,Data!$Z:$Z,"="&G2)

EDITED to allow you to use whole column ranges.

It may have to do with the greater than and less than signs on either side of the N/A without the quotes.

Edit: BTW a sumif would work as well, you don’t really need a sumifs for that.

Cell F2 formula , Drag down

Formula:

Please Login or Register  to view this content.

Cell F2 formula , Drag down

Formula:

Please Login or Register  to view this content.