Lookup matching txt in one column then sum same row in three other columns

**des333** · 01-31-2013, 06:52 PM

I want to look up the word "cash" in one column then on the same row, in three other columns to the left, sum those three figures. There may be more than one "cash" row so the total of all the rows need to be added together to give a. total for each of the three columns and b. one nett total.

**dredwolf** · 01-31-2013, 07:00 PM

I would want to see a sample workbook for something like this, showing some sample data, expected output and description of why the out put should look like that

**des333** · 01-31-2013, 07:18 PM

Pls see attached

**des333** · 01-31-2013, 07:25 PM

So I need to find "cash"in the column marked Final Payment (Col M) and then in Cols E, F & G add the figs together on the same row. Then sum each of the same figs in each column (E F G)

**Pete_UK** · 01-31-2013, 07:44 PM

You could use this formula:

=SUMPRODUCT(($M$3:$M$9="cash")*($E$3:$G$9))

Hope this helps.

Pete

**dredwolf** · 01-31-2013, 09:18 PM

This applies to your sample:

for your row totals put this in T3

Formula:

Please Login or Register  to view this content.

drag down

in T10:

Formula:

Please Login or Register  to view this content.

in T11: use Pete's formula

this will give you a cross check to make sure ther is nothing going strange on you..

Hope this helps

**des333** · 02-02-2013, 05:59 AM

Pete and Dred... you guys are my heros! Such intellect and so easily available! You've savedme so much hassle and consternation.

**Pete_UK** · 02-02-2013, 07:34 AM

Thanks for the kind words.

If you think this thread has now been solved please mark it as such - click on Thread Tools above your first post, then Mark as Solved.

Pete