I´m making a large document to register workdays and holidays from work .

Using the IF formula but must use many IF formula since I do not get to collect more cells in a formula

NORWEGIAN TRANSLATE: HVIS = IF


=(HVIS(Registrering!AE36="RA";HVIS(Registrering!AF36="T";Kode!B4))+(HVIS(Registrering!AE37="RA";HVIS(Registrering!AF37="T";Kode!B4))+(HVIS(Registrering!AE38="RA";HVIS(Registrering!AF38="T";Kode!B4))+(HVIS(Registrering!AE39="RA";HVIS(Registrering!AF39="T";Kode!B4))+(HVIS(Registrering!AE40="RA";HVIS(Registrering!AF40="T";Kode!B4))+(HVIS(Registrering!AE41="RA";HVIS(Registrering!AF41="T";Kode!B4))+(HVIS(Registrering!AE42="RA";HVIS(Registrering!AF42="T";Kode!B4))+(HVIS(Registrering!AE43="RA";HVIS(Registrering!AF43="T";Kode!B4))))))))))

can anyone help me?

I was hoping for this: =HVIS(Registrering!AE36:Registrering!AE43="RA";HVIS(Registrering!AF36:Registrering!AF43="T";Kode!B4)
But this does not work