Check if last 3 cells in a row are "A" if so = 1

[lars1565]

I have a spreadsheet for attendance at a school. I want to be able to flag students who have missed the last 3 days of a class. So I want a formula that will look at the last three entries of a row and see if the last three cells all contain "A." If so I would I would like it to return 1. I have found lots on averaging the last 3 cells but I can not figure how to change it so it does it what I want.
Thanks

 

[Aladin Akyurek]

Try...

=ISNUMBER(MATCH("A",OFFSET(INDEX($1:1,MATCH(REPT("z",255),$1:1)),0,0,,-3),0))+0

which test row 1.

 

[Scott Huish]

I think that will only check to see if any of the last 3 values is an A, not all of them.

Perhaps:
=(COUNTIF(OFFSET(INDEX($1:1,MATCH(REPT("z",255),$1:1)),0,0,,-3),"A")=3)+0

 

[Aladin Akyurek]

I think that will only check to see if any of the last 3 values is an A, not all of them.

Perhaps:
=(COUNTIF(OFFSET(INDEX($1:1,MATCH(REPT("z",255),$1:1)),0,0,,-3),"A")=3)+0

You are right. The OP mentions "all", so COUNTIF instead of ISNUMBER+MATCH will do.