Sheet1 - Exceladvise.com

Document Sample
Sheet1 - Exceladvise.com Powered By Docstoc
					Commission                       3%


Date           Region   Type          Sales          Commission
 02-May-10     East     Male                  3196       95.88               =SUMIFS(sum_range, criteria_range1, crite
  21-Sep-09    West     Male                  2271       68.13
  25-Jan-11    North    Male                  7016      210.48    Male          162179       49%
  08-Sep-09    South    Female                9446      283.38    Female        167630       51%
  07-Jun-10    East     Male                  9925      297.75
  11-Feb-10    West     Female                9073      272.19                  329809
   09-Jul-10   North    Female                5848      175.44
  24-Sep-10    South    Female                3915      117.45    Values less 2010 Jan
  01-Apr-10    East     Female                7947      238.41
 24-Nov-09     West     Female                9135      274.05
 15-Aug-09     North    Male                  9298      278.94
  13-Apr-10    South    Female                5035      151.05
 09-Nov-10     East     Male                  1561       46.83
  12-Oct-09    West     Male                  6316      189.48
  15-Sep-09    North    Male                  1597       47.91
 09-Nov-09     South    Female                3263       97.89
  23-Feb-11    East     Female                9847      295.41
 14-Mar-11     West     Female                7033      210.99
 23-Dec-10     North    Male                  4813      144.39
  24-Apr-11    South    Female                7429      222.87
  04-Jan-10    East     Female                5574      167.22
  14-Jan-10    West     Male                  2792       83.76
 27-Mar-10     North    Female                8895      266.85
   29-Jul-10   South    Male                  3718      111.54
  21-Apr-10    East     Male                  6065      181.95
  28-Sep-09    West     Female                3928      117.84
   28-Jul-09   North    Male                  9058      271.74
  22-Apr-10    South    Male                  2263       67.89
  03-Feb-11    East     Female                4433      132.99
 18-Nov-10     West     Male                  6339      190.17
  19-Sep-09    North    Male                  2795       83.85
  07-Feb-11    South    Female                3334      100.02
 01-Nov-10     East     Male                  4111      123.33
 17-Mar-11     West     Male                  2127       63.81
 09-Nov-10     North    Male                  8659      259.77
  31-Oct-09    South    Male                  1650        49.5
  17-Sep-10    East     Female                5388      161.64
  02-Jun-11    West     Female                4413      132.39
  18-Sep-09    North    Male                  2714       81.42
   09-Jul-10   South    Female                5879      176.37
  04-Feb-11    East     Male                  3886      116.58
 25-Dec-09     West     Male                  3077       92.31
 07-Oct-09    North   Male       5517   165.51
03-Mar-10     South   Female     5220    156.6
23-Nov-10     East    Female     2635    79.05
31-Aug-10     West    Female     2216    66.48
  25-Jul-10   North   Female     4580    137.4
14-Mar-10     South   Male       4421   132.63
 11-Oct-10    East    Male       1037    31.11
 24-Oct-09    West    Male       9415   282.45
30-Aug-10     North   Male       2457    73.71
 27-Sep-09    South   Female     6469   194.07
 02-Oct-09    East    Female     1971    59.13
 19-Apr-10    West    Female     4385   131.55
01-Mar-10     North   Female     4115   123.45
22-Nov-10     South   Female     1630     48.9
27-Aug-10     East    Male       5385   161.55
24-Nov-10     West    Male       6632   198.96
01-Nov-10     North   Male       2883    86.49
 15-Jan-11    South   Female     6490    194.7
08-May-10     East    Female     8104   243.12
26-Nov-09     West    Male       1024    30.72
01-Aug-09     North   Male       9632   288.96
  14-Jul-10   South   Male       8529   255.87

                               329809
um_range, criteria_range1, criteria1)




              273801

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:3/8/2012
language:
pages:3