Thread: Checking a value is present in each and every cell in a range

Hi everyone,

I am trying to create a spreadsheet to track/summarise my student's progress. I have an excel sheet with a page for each subject they are doing. Each page has a column for each of that subject's modules.

A simplified version is below;

Name ¦ English Writing ¦ English Language ¦ English Oral ¦ Summary
Jessica ¦ P ¦ (null or F) ¦ P ¦ Fail
Sally ¦ P ¦ P ¦ P ¦ Pass

I need to know what the forumla is I would need in the Summary section. I can get it to work if I want to check only one cell, but I can't suss it out for multiple cells.

Any help would be appreciated.

Thanks

Name____¦_English Writing_¦_English Language-¦_English Oral_¦_Summary
Jessica___¦_______ P_____¦_(null or F)_______¦____ P______ ¦_ Fail
Sally_____¦_______ P_____¦_____ P_________ ¦____ P______ ¦_ Pass