what is the formula

[Guest]

I have a SPR of payments received into our bank account in column c and in
column E I have the initials of the person who will earn commision on that
payment. What I want to do is obtain the total sum of payments received for
that person.

so what is the grand total of the payments received in column C for the
person who's intials are in ccolumn e?


Kind regards
Megan

 

[Guest]

SUMPRODUCT works great for these kinds of problems. Let's say your payments
are in C2:C20 and the salesperson's initials are in E2:E20. Starting in E22
(or any convenient cell for that matter), list each person's unique initials,
one row per salesperson. Then in cell C22 (or an adjacent cell to the
initials), enter the following formula

=SUMPRODUCT((E22=$E$2:$E$20)*($C$2:$C$20))

Copy down the formula for as many rows as you have initials.

 

[Guest]

=SUM(IF(F1:F100="m.e.",C1:C100))
This is an array formula entered with:
CNTRL-SHFT-ENTER
rather than
ENTER


Change the initials to suit.

 

[Peo Sjoblom]

=SUMIF(F1:F100,G1,C1:C100)


where you would put the initials of the person you want to sum for in G1

adapt to fit to your own range etc


--


Regards,


Peo Sjoblom

 

[Guest]

Are there any reasons why this array formula would be better than using
=SUMIF ?