I am trying to use a formula to show the following sentence, as the information changes monthly:

IF it is a Class A project, [B]AND[B/] is Completed, THEN show the project name.

I believe this is what I need but I think it comes out with #VALUE! because I am trying to take more than one cell into account:

=IF(AND(AS9:AS48="Completed",H9:H48="A"),F9:F48,"")

Could anyone help with this so my formula shows all project names that are completed AND class A?

P.S. I'm using a COUNTIFS formula which comes up with the same answer BUT I don't want to count the number of projects, I want the project names to show...