title: SUMIF Horizontal
body: <p>I am searching for a column header and return a value under it.</p>
  
  <p>Example:</p>
  
  <p>_|A|B|C</p>
  
  <p>1|X|Y|Z</p>
  
  <p>2|1|2|3</p>
  
  <p>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.</p>
  
  <p>I would appreciate your support! </p>