Excel

March 3rd, 2006 by eyal | Filed under Techie. |

I’m trying to do something with Excel and was wondering if someone out there knows how to do this.

In a table, look up a value in cells in column A, for every occurence of value X in column A lookup value on a column B same row cell.

So if X shows up in A3 and A5 and A20 then I want to add the values from B3 and B5 and B20 and post the sum to some other cell, say E1.

Any ideas?

Other possibly related posts:

richard | 3/03/06
look for help on the SUMIF function.
eyal | 3/03/06
That’s exactly what I needed. Thanks Richard.
gab | 4/03/06
Look up sumproduct:

=SUMPRODUCT((B4:B43)*(A4:A43=”X”))
eyal | 5/03/06
hi gab, thanks. I’ve got it working with the SUMIF but will keep this in mind when trying other stuff.

cheers
eyal