# SUMIF - HLOOKUP Combination

1. ## SUMIF - HLOOKUP Combination

I have a sumif formula where the sum_range is a specific column.

The column varies from month to month. I can identify the column by using
the hlookup function.

Can I return the column letter to the sumif function using the hlookup?
Normally the hlookup returns the value and not the cell address.

Is there another function I am not aware of that will accomplish this?

2. ## Re: SUMIF - HLOOKUP Combination

Mark,

Instead of HLOOKUP, use a combination of Index and Match. For example, if
cell A1 has a value that matches a header in row 3, and that is the column
you want to pass to the SUMIF

=SUMIF(A3:A100,"A",INDEX(3:100,,MATCH(A1,3:3,FALSE)))

HTH,
Bernie
MS Excel MVP

"Mark" <Mark@discussions.microsoft.com> wrote in message
news:FC7439A9-6F3E-4F4A-B29B-D26CDB39F905@microsoft.com...
> I have a sumif formula where the sum_range is a specific column.
>
> The column varies from month to month. I can identify the column by using
> the hlookup function.
>
> Can I return the column letter to the sumif function using the hlookup?
> Normally the hlookup returns the value and not the cell address.
>
> Is there another function I am not aware of that will accomplish this?
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1