SORT causing #VALUE error in {SUM(COUNTIFS}

First time here.... Thanks for all the know how sharing.

Formula is ok until after i sort...

I have a problem i have a{= IFS(COUNTIFS(), SUM(COUNTIFS(), SUM(COUNTIFS()},... that references other worksheets (Ref!, Sort!). I am not using named tables only "ref!$A$3, etc.

I am having trouble adding a condition to count dates. They are formatted as GENERAL. If I manually retype the syntax into the formula it will work until I run a (recorded) macro to sort the data After i run the "sort" macro or manually sort via toolbar it gives me a #VALUE error. Then I have to retype the darn thing in the formulas again. The formula works fine for the yearly table but not for the monthly, when i added the monthly sort data it is showing #VALUE. I eve tried coping the line from the yearly sort table but after I sort it goes to #VALUE again. This might be the death of me. HELP

The formula evaluation tool seems to think there is text in the formula, but i checked it and reformatted. I also copy and paste it when entering it again.

Full Disclosure: I am not good at Excel at all. I am doing the "hey, Ill look on google for this one", as i write the spreadsheet.

Thanks all,

I attached a reduced file with the sensitive information scrubbed. The problem is in Matrix!AD6:AD11 a similar function is in Matrix!M6:M11. The #REF errors ar due to my scrubbing the document of other information. Thank you for looking at this for me.

XOR LX; You sir, are a genius! That fixed it! I just verified it on the original sheet. Truly, I owe you one!!
This forum is the best thing ever!!!! Thanks to all for sharing all your knowledge with everyone.