Here is what I am trying to do

a name is assigned either an "M" or "A" in sheet 1 column A
The sheet that I work with has 50 sheets. the sheets are assigned to an individual and are numbered according to row number of the individuals name.
for names that are assigned "M" the total of O32:O42 of their individual sheet must total at least 5 and return yes, if less than 5 must return no.
for names that are assigned "A" the total of O32 of their individual sheet must total at least 1 and return yes, if zero must return no.

My thought in creating the formula;

if the value in column D*="M" then the true argument IF(SUM('5'!$O$32:$O$42)>=5, will return "Yes"
the false argument would mean D*="A" so i used a second if argument IF('5'!$O$32>=1, to validate if true and return "Yes"
The false argument would mean that both the "M" and "A" argument is false and return "NO"