How to add values in columns

[dstin44]

Lets, say I will have 3 sets of 100 keywords, first in column A, second in column D, and the third one in column G. Column B will be search volume for these keywords from AdWords Keyword Planner, and column C seo competition values from SemRush (the same will go from columns, EF, and HI).

It will be the same keywords, but with different city values, organized in the same alphabetical order, so it will look something like this:

online dating Chicago - 90 - 89.1 - online dating phoenix - 70 - 71.6 - online dating Philadelphia - 65 - 81.3
adult dating Chicago - 80 - 71.2 - adult dating phoenix - 80 - 84.1 - adult dating Philadelphia - 70 - 75.6

and so on...

How to add whats in columns B, E, and H (search volume) and columns C, F, and I, and output it, lets say in J and K. This way I would have a total search volume for "online dating <city>" in column J, and total seo competition for "online dating <city> in column K?

As detailed, step by step info as possible, would be the best, as I am not very familiar with Excel, at this point. I've been using it, but I am planning to read some books, and so on.

Thanks.

[jayajaya_4]

pls attach a sample file for better results and response

[teylyn]

Hello,

assuming your data starts in row 2 and row 1 has labels, you can use this formula into J2 and copy down

=B2+E2+H2

or

=sum(B2,E2,H2)

Similarly in cell K2:

=C2+F2+I2

or

=sum(C2,F2,I2)

The Sum() function will tolerate text in the cells, the formula with the + signs will not. If your data comes from the web, it's likely that seemingly empty cells will contain blanks, so using Sum() is probably your better option.

cheers, teylyn