Improve IF formula

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

Try

=IF(COUNTIFS(Registrering!AE36:AE43;"RA";Registrering!AF36:AF43;"T")>0;Kode!B4;"")

Hi

Thanks! That works great!

You're welcome.

Hi

Now I´m Trying to do this
=HVIS(ANTALL.HVIS.SETT(Registrering!C23:C30;Registrering!C36:C43;Registrering!C49:C56;"RA";Registrering!D23:D30;Registrering!D36:D43;Registrering!D49:D56;"T")>0;Kode!B4)

But this dosen´t work. Any sugestion?

=HVIS(ANTALL.HVIS.SETT is =IF(COUNTIFS

Thanks

What is in the 'Between' cells (C31 to C35, C44 to C48, etc..) ?

If those cells will NOT contain the "RA" (likewise for "T" in the D rows),
You can just do
=HVIS(ANTALL.HVIS.SETT(Registrering!C23:C56;"RA";Registrering!D23:D56;"T")>0;Kode!B4)

I can do that. But it wil only register one RA and on T

So if I put RA in C23 and T in D23 it wil not register the RA in C235 and T in D235.....

Wait, is Kode!B4 a numeric value?

Try
=ANTALL.HVIS.SETT(Registrering!C23:C56;"RA";Registrering!D23:D56;"T")*Kode!B4

Yeah it´s numeric value, sry for not saying.

But the new formula works! Thanks!

And if the value is a date?
Registrering!E112 = 13.july
Registrering!AB112 = 7 august
Registrering!AX112 = 9 sep

Formula inn cell Z11
=ANTALL.HVIS.SETT(Registrering!E10:E368;"RA";Registrering!F10:F368;"T");Registrering!E112) ?

And I will have all the dates in cell Z11, so I would like to bee like this inn cell Z11 "13.july - 7 august - 9 sep"

Do you know Thanks for all your help.