Multiple countifs within 2 if functions

[mtaylor]

Hi folks,

I am working on a register for online students.

Over the course of a day (7 lessons), if a student has more than 3 'TRUE', 'R' or 'L' values between D4 and J4 a 'P' appears, if a student has more than 2 'AA' values between D4 and J4 a 'AA' appears, if neither of these apply a 'UA' appears.

The 'true', 'r' and 'l' must take preference over the 'aa'

I currently have this:

=IF(COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L")))>3,"P",IF(COUNTIF(D4:J4,"AA")))>2,"AA""UA"

It doesn't work

Thank you in advance,

I hope I'm making sense?

 

[etaf]

But I think Brackets and , are missing

=IF(COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L")))>3,"P",IF(COUNTIF(D4:J4,"AA")))>2,"AA""UA"

COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L")))>3
should be
(COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L"))>3
This will TEST ALL the additions of the COUNTIF

SO
=IF((COUNTIF(D4:J4,TRUE)+COUNTIF(D4:J4,"R")+COUNTIF(D4:J4,"L"))>3,"P",IF((COUNTIF(D4:J4,"AA"))>2,"AA","UA"))

 

[mtaylor]

But I think Brackets and , are missing

=IF(COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L")))>3,"P",IF(COUNTIF(D4:J4,"AA")))>2,"AA""UA"

COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L")))>3
should be
(COUNTIF(D4:J4,TRUE)+(COUNTIF(D4:J4,"R")+(COUNTIF(D4:J4,"L"))>3
This will TEST ALL the additions of the COUNTIF

SO
=IF((COUNTIF(D4:J4,TRUE)+COUNTIF(D4:J4,"R")+COUNTIF(D4:J4,"L"))>3,"P",IF((COUNTIF(D4:J4,"AA"))>2,"AA","UA"))

Brilliant - Many thanks

 

[etaf]

you are welcome