title: For all location in array x equal to z, sum corresponding location in array y
body: <p>I am looking for a function that sums all values in columns (F, L, R ... n) if their corresponding values in rows (C, I, O ... n-3) equals eg. "A".</p>
  
  <p>If if was only a few columns I would use sumif for each column, but i have to repeat this 600 times for 50 different values ( A, B, C ...)</p>
  
  <p>I have tried SUM(IF(C9:O57="A";F9:R57)) which worked at first, but in my 'real document' it returns "0", when I copy it.</p>
  
  <p><a href="https://i.stack.imgur.com/slM2m.png" rel="nofollow noreferrer">Example</a></p>