Hopefully someone can help me as this has me stumped all afternoon!

I have a spreadsheet and I have two columns that are added up to get the average. The formula i'm using is this:


I want to add columns B, C, D, E, F, G & J together - skipping columns H and I (titled OR and RP).

How can I do this? I keep getting a syntax error in column K, which is supposed to be the total of B, C, D, E, F, G & J.

I have added a picture, so hopefully it will make more sense.enter image description here

1 Answer 1


I presume you want to add those columns row by row. If so, write


in Cell K2 and then copy and paste it to the cells below.

  • 1
    Thank you so much, such an incredibly easy solution!!! I was copying all of these complex things that I'd found online and nothing was working. Stackexchange wont let me upvote you, but thank you again!
    – Klitiko
    Sep 19, 2021 at 17:54
  • Good answer! I’ll upvote it :)
    – bjbk
    Sep 19, 2021 at 19:10

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .