Excel

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

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:

« Frustrating day
TLAB and RBAK »

4 Responses to “Excel”

  1. richard | 3/03/06

    look for help on the SUMIF function.

  2. eyal | 3/03/06

    That’s exactly what I needed. Thanks Richard.

  3. gab | 4/03/06

    Look up sumproduct:

    =SUMPRODUCT((B4:B43)*(A4:A43=”X”))

  4. 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

Share Your Thoughts