1

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:

AVERAGE H2,I2

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

2

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

=SUM(B2:G2,J2)

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

2
  • 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 '21 at 17:54
  • Good answer! I’ll upvote it :)
    – bjbk
    Sep 19 '21 at 19:10

You must log in to answer this question.

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