Lookup and Sum

[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

 

[Jason Morin]

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

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

HTH
Jason
Atlanta, GA