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,