I am searching for a column header and return a value under it.
Example:
_|A|B|C
1|X|Y|Z
2|1|2|3
If the value is Y
, it must return 2
. I tried =SUMIF(A1:C1,"B", A2:C2)
, but realized that IFSUM does not support searching horizontal.
I would appreciate an alternative solution!