Hello,
I am quit new in this site and in VBA.
I wrote a formula that works well in excel but when I register a macro system gets a Debug (Run-time error '1004')

Formula is as follow:

=SUMIFS(List!$G:$G;List!$BH:$BH;"No";List!$AK:$AK;"<>Yes";List!$AO:$AO;"<>Yes";List!$AL:$AL;"<>Yes";List!$AM:$AM;"<>Yes";List!$AN:$AN;"<>Yes";List!$J:$J;"X")-SUMIFS(List!$AI:$AI;List!$BH:$BH;"No";List!$AK:$AK;"<>Yes";List!$AO:$AO;"<>Yes";List!$AL:$AL;"<>Yes";List!$AM:$AM;"<>Yes";List!$AN:$AN;"<>Yes";List!$AA:$AA;"Yes";List!$AB:$AB;"<>Yes";List!$J:$J;"X")-SUMIFS(List!$AJ:$AJ;List!$BH:$BH;"No";List!$AK:$AK;"<>Yes";List!$AO:$AO;"<>Yes";List!$AL:$AL;"<>Yes";List!$AM:$AM;"<>Yes";List!$AN:$AN;"<>Yes";List!$AB:$AB;"Yes";List!$J:$J;"X")

I have other similar formulas after that works perfectly when I type, but not when I register.
Can you help me please?

Thank you in advance
Michela