How to obtain the address of a column?

Hi,

It's my first post, I think it's an hard one. I just spent an hour on google without finding any solution.

First of all, I know it would be easily done with a macro but the challenge is to do it without.

I would like to use a function like SUMIF -> =SUMIF(A:A,G2,B:B) (Sum the column B if the cell of the column A is like G2).

What I don't know is which column do I have to sum (I don't know the B) so I could use a combination of ADDRESS and MATCH -> =LEFT(ADDRESS(1,MATCH(H1,1:1,0),4)) (it gives "B")

The problem is that this "B" is a text format and not and address format so when I put this "AddressMatch Combination" in my sumif function it gives me an error.

What can I do?

Thank you and I apology for my poor English

Maxexample.xlsx

Hi, and welcome to the forum.

Place this formula in cell H2: =SUMIF($A:$A,$G2,INDEX($B:$C,,MATCH(H$1,$B$1:$C$1,0)))
drag it over and down

And no need to apologize for your English - it is very good. Far superior to my Dutch, French or German.

with a pivot table (draaitabel).

Thank you Cutter,

Exactly whath i needed.

Thx for you answer Oeldere, that's the solution given by my brother in law when we talked about it last week-end!

Max

You're welcome.