My sheet looks something like this: enter image description here

I'm trying to create a formula for the Total profit column, which would be the sum of the winnings/losses for that person for that row. So for instance, for Person1, the value would be -41.15, (i.e. -70 + 13.05 +15.8).

My approach was something like this: Get the columns that have at least one cell that has the exact value "Winnings/Losses". From those columns, sum over the values from the row that corresponds to the current person.

I've been trying to use formulas like FILTER, ARRAYFORMULA, VLOOKUP, etc, to no avail, I just can't seem to get them to do what I want. I've found the sheet formulas to be non-intuitive. probably because I come from an imperative programming background (C, Python, Typescript, etc). Any help is appreciated.

  • What is wrong with =E1+H1+J1?
    – Tedinoz
    Feb 13, 2020 at 7:44
  • I am going to have a very large number of the three-column sections, such that manually entering their column/row addresses would be come cumbersome and error-prone
    – vasia
    Feb 13, 2020 at 15:31
  • "I am going to have a very large number of the three-column sections" All we can do is answer your question based on the information that you supply. There's no mention of a very large number of the three-column sections; if that is a critical issue, then please edit your question accordingly. You might also want to quantify "a very large number" - this means all things to all people.
    – Tedinoz
    Feb 13, 2020 at 23:13

1 Answer 1


You can try =sumif()


enter image description here

Here's a dummy sheet

You just need to replace B with Winning/Losses or whatever you need.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.