IF/AND SUM MULTIPLE CRITERIA

[Claire Jackson]

Hi, I am trying to do an if sum with and with 6 different criteria. Can you advise where I'm going wrong please:

=IF(AND(A2="matt jackson",69,b2="not on site",70, IF(AND(A2="andy campbell",79,b2="not on site",80,IF(and(A2="kelvin green",89,b2="not on site",90))))

 

[Claire Jackson]

Thanks again, so for B2 it's just adding 1, right?

 

[Fluff]

Only if it's "not on site" otherwise it adds 0

 

[Claire Jackson]

Great, thanks again

 

[Fluff]

My pleasure.