View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Håkan Björkström Håkan Björkström is offline
external usenet poster
 
Posts: 4
Default Sumifs referring to columns defined by header

Hi

I need to use SUMIFS, where sum values and criteria values are in columns with column header (normal excel sheet). How can I refer to column headers instead of absolut address? Depending on the criteria value, different columns have to be calsulated.

rgds
Håkan