I would like to add the total minutes spent by each person and output the sum to column E.
\1
For example, if “jerr” was present for BossFight’s 1, 2, and 3 then I want to add the given values for those Bossfight’s to jerr and get his total.
If there is TEXT in column B4, add value in B2
If there is TEXT in column C4, add value in C2
If there is TEXT in column D4, add value in D2
Output sum to E4
So “jerr” would equal 20
“sab” = 14
“pete” = 10
How would I go about doing this?
Bookmarks