In google spread sheet, Given the following:
John 5 Peter 0 Brad 3 Smith 1 Grade1 1 Grade2 2 Grade3 3 Grade4 4 Pass 5 Fail 0
I want to do the following, when I write in the same row say (John Grad1 Pass), it should sum all values of each word, so I should get "11" in this case. Below some examples:
Peter Grade2 Fail 2 Smith Grade4 Pass 10
How can I do this?