add the total grade of frank, using if statements.

using excel, but don't use the traditional =J4+J8. use any other way, you can use if starements or any other way which is convenient and time efficient

K will hill michael frank will hill michael frank J 67 43 66 87 75 87 56 79