View Single Post
  #1   Report Post  
Mark
 
Posts: n/a
Default 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?

Thanks for your help.