Hello

I have this excel formula that works in most cases:

= IF(ISNUMBER(MATCH($F5,txdata!$M:$M,0)),SUMIFS(txdata!$Y:$Y,txdata!$M:$M,$F5,txdata!$AB:$AB,"=A*"),0)

however, once in a while in would give me that message:

=IF(ISNUMBER(MATCH($F5,txdata!#REF!,0)),SUMIFS(txdata!#REF!,txdata!#REF!,$F5,txdata!#REF!,"=A*"),0)

 I am trying to avoid that error from happening again. Could someone tell me why it is happening?