software

My task is to track commissions for a small agency. I have created a
workbook that includes a worksheet for each provider which lists the
customer, amount paid, whether or not it is a renewal and which agent is due
the commission. I then have worksheets for each agent where I have copied
the rows that apply to the agent from each of the provider sheets. Using if,
then logic I get a total of first year and a total of renewal commissions.
For some of our more productive agents the formula can't be big enough. At
my beginner level I was proud of what I had created, but looking at the
groups I know I can do better. What do I need to study? arrays macros loops
I might be in over my head. Anybody have a suggestion?

Look at the DSUM function, it might do what you want.

quot;workerbeeVABquot; wrote:

gt; My task is to track commissions for a small agency. I have created a
gt; workbook that includes a worksheet for each provider which lists the
gt; customer, amount paid, whether or not it is a renewal and which agent is due
gt; the commission. I then have worksheets for each agent where I have copied
gt; the rows that apply to the agent from each of the provider sheets. Using if,
gt; then logic I get a total of first year and a total of renewal commissions.
gt; For some of our more productive agents the formula can't be big enough. At
gt; my beginner level I was proud of what I had created, but looking at the
gt; groups I know I can do better. What do I need to study? arrays macros loops
gt; I might be in over my head. Anybody have a suggestion?

Sounds like some sort of conditional SUM, such as SUMIF.

Example,

=SUMIF(A:A,quot;Bill Dean,quot;C:C)

calculates the total amount in C where the value in A is Bill Dean.

Other than that, a bit more detail might help.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;workerbeeVABquot; gt; wrote in message
...
gt; My task is to track commissions for a small agency. I have created a
gt; workbook that includes a worksheet for each provider which lists the
gt; customer, amount paid, whether or not it is a renewal and which agent is
due
gt; the commission. I then have worksheets for each agent where I have copied
gt; the rows that apply to the agent from each of the provider sheets. Using
if,
gt; then logic I get a total of first year and a total of renewal commissions.
gt; For some of our more productive agents the formula can't be big enough.
At
gt; my beginner level I was proud of what I had created, but looking at the
gt; groups I know I can do better. What do I need to study? arrays macros
loops
gt; I might be in over my head. Anybody have a suggestion?

Over your head!!!....not at all!
Give an example of your IF formula and somebody will lead you in the
right direction.

some of the funtions:
VLOOKUP
HLOOKUP
INDEX,MATH
SUMPRODUCTRegards
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=498047YIPPEE, thanks so much!

quot;Marvin P. Winterbottomquot; wrote:

gt; Look at the DSUM function, it might do what you want.
gt;
gt; quot;workerbeeVABquot; wrote:
gt;
gt; gt; My task is to track commissions for a small agency. I have created a
gt; gt; workbook that includes a worksheet for each provider which lists the
gt; gt; customer, amount paid, whether or not it is a renewal and which agent is due
gt; gt; the commission. I then have worksheets for each agent where I have copied
gt; gt; the rows that apply to the agent from each of the provider sheets. Using if,
gt; gt; then logic I get a total of first year and a total of renewal commissions.
gt; gt; For some of our more productive agents the formula can't be big enough. At
gt; gt; my beginner level I was proud of what I had created, but looking at the
gt; gt; groups I know I can do better. What do I need to study? arrays macros loops
gt; gt; I might be in over my head. Anybody have a suggestion?