Lookup and Sum

  • Thread starter Thread starter John Kiser
  • Start date Start date
J

John Kiser

I have an array of data like this....


A B A
1 2 3
4 5 6
7 8 9

I want to sum the 2nd row of numbers for every column
where the column title is the letter "A". In the case
above, I want the formula to return the number 10 (i.e. 4
+ 6).

How do I do that?

Thanks

John
 
If your array were in A1:C4, you could use:

=SUMIF(1:1,"A",3:3)

HTH
Jason
Atlanta, GA
 
Back
Top