Patrick,

You might also be interested in the SumProduct worksheet function.
This one will look at values in one column and pull out only those matching
one criteria.
Than you can add additional columns to do the same. And than add the last
column which is the value column (to add up). The result is the sum for all
the concurrent matches.

But again - we need details on how your columns are set up...

--
steveB

Remove "AYN" from email to respond
"Patrick Young" wrote in message
...


Please help me write the function that would match the Month and the
Sales to give me the amount of Commission for each combination of Month
and Sales Value.



Thanks,





Patrick





Month Sales Commission

May-05
-
-

May-05
$ 297,409
$600

May-05
$ 1,000,000
$833

Jun-05
-
-

Jun-05
$ 330,515
$800

Jun-05
$ 1,500,000
$900

Jul-05
-
-

Jul-05
$ 298,390
$500

Jul-05
$ 1,700,000
$1500

Aug-05
-
-

Aug-05
$ 341,568
$400

Aug-05
$ 1,900,000
$600

Sep-05
-
-

Sep-05
$ 319,376
$700

Sep-05
$ 2,000,000
$1500

Oct-05
-
-

Oct-05
$ 379,096
$200

Oct-05
$ 1,000,000
$1800