Summing a range in a variable column

**andrewc** · 10-23-2015, 09:50 AM

Hi,

I have sample data in columns A to C of the attached file and would like to calculate in cell G2 the total value from columns B and C for the country indicated in cell F2.

So, for example, F2 contains the country “Belgium” so the formula in G2 should return the sum of all values in column C.

The wrinkle is that when I receive the data next month the column headed “Belgium” may not be in column C; it could be in any column from B to Z.

Can someone please suggest a formula to use in G2 that will achieve this?

Thanks!

PS I realise that the data in columns F and G should be further to the right to accommodate data in the columns to Z; I’ve placed it where it is to make the worksheet easier to read.

**AlKey** · 10-23-2015, 09:57 AM

Hi Andrew,

Try this formula

=SUM(INDEX($B$2:$C$7,0,MATCH(F$2,$B$1:$C$1,0)))

**andrewc** · 10-23-2015, 10:07 AM

Thanks very much!

**newdoverman** · 10-23-2015, 10:44 AM

I suggest that you put AlKey's formula on a separate worksheet and not in column G with the following amendment. This would allow for data to be to column Z as you state and as many rows as is required.

This is just an "expansion" of AlKey's formula in case you were wondering how to accommodate the data that you indicate that you might get.

Formula:

Please Login or Register  to view this content.

Summing a range in a variable column

LinkBack

Thread Tools

Rate This Thread

Display

Summing a range in a variable column

Re: Summing a range in a variable column

Re: Summing a range in a variable column

Re: Summing a range in a variable column

Thread Information

Users Browsing this Thread

Similar Threads

Summing with a variable range

Summing Variable Range in a Column from Below

[SOLVED] Summing a variable range of columns

Summing a variable range of columns

Summing a variable range of columns

[SOLVED] Summing a variable range of columns

Summing a variable range of Columns

Bookmarks

Bookmarks

Posting Permissions