Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Summing up cells based on names in adjoining cells - I'm new to using functions

6 views
Skip to first unread message

Stupidparrpt

unread,
Nov 6, 2012, 1:29:12 PM11/6/12
to

I have a column with agent commissions for sales orders. Next to this
column I have a column with the agents identifier (names in this case).
I want to create individual cells that total each agents commissions at
the bottom of the spreadsheet.




--
Stupidparrpt

Spencer101

unread,
Nov 6, 2012, 3:02:40 PM11/6/12
to
Have a look at the attached. Without an example worksheet it's hard to
tailor make an example, but it should give you the idea.

I've included a SUMPRODUCT and a SUMIF version.

You could also use a pivot table.

Let us know if you need further help with adapting it to your specific
workbook.


+-------------------------------------------------------------------+
|Filename: Stupidparrpt Example.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=668|
+-------------------------------------------------------------------+



--
Spencer101

Stupidparrpt

unread,
Nov 6, 2012, 5:58:14 PM11/6/12
to

Works perfectly - thanks very much!


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Stupidparrpt
0 new messages