Total by contents of a different column

[OEGInc]

I’m not really sure how to explain this without giving an example, so let’s take the following. Picture a sales log

Saleman | Qty of Item A sold | Qty of Item B sold | Sale $

So it might look like this

Smith 1 0 $1000

Jones 0 1 $1000

Smith 1 1 $2000

Hancock 1 0 $1000

Smith 0 1 $1000

And now I want to create an “overview” of the sales, so I want to lookup Column A and add Column B or Column C, so I might have this:

Salesman | Total Items | Total $ Sold

Smith 4 $4000

Jones 1 $1000

Hancock 1 $1000

Basically for Column B for Smith I want to say:
SUMIF (A1:A100, “Smith”, B1:C100) or something like that… But it doesn’t seem to work!?

Hopefully you understand, I’m sure this is fairly common thing to do, I’ve needed to do it 100 times already - but now I’m determined to figure it out!

[ROSt53]

Did you try to see if Data > Subtotals delivers the results you need?

It can look like:

or

You also can use a Pivot Table and get

It depends on how you want to use the results thereafter

[OEGInc]

I think this is a misunderstanding, I don’t want Sum Qty A and Sum Qty B, I want Sum Qty Total for each sales person that matches. I have my “Sales Log” on one page, and my “Sales Overview” on a different page which doesn’t Date->Subtotals doesn’t seem to support at all.

[karolus]

Hallo

May I give you a Hint?

Karolus

[ROSt53]

@karolus - Thanks for this excellent hint. Document looks pretty good!

[OEGInc]

I don’t seem to have DataPilot, I’m running LibreOffice 4.3.5 which appears to be the latest available.