Hi,

Am Mon, 16 Apr 2018 03:42:59 -0700 (PDT) schrieb Håkan Björkström:

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.

your data in A1:G20. Then:

=INDEX(A1:G20,,MATCH(yourheader,A1:G1,0))


Regards
Claus B.
--
Windows10
Office 2016