Spreadsheet: 48627d1247845663-how-to-use-sumproduct-with-multiple-criteria-example
Sheet: data

 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00
Specialty | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00
VASCULAR SURGERY | 910.71 | 1221.4 | 1056.2 | 748.85 | 1155.06 | 1183.7 | 1221.94 | 1069.97 | 1078.78 | 976.58 | 822.91 | 739.79 | 915.8
VASCULAR SURGERY | 656.32 | 1419.55 | 480.07 | 1337.8 | 1818.02 | 273.94 | 1215.14 | 1032.82 | 958.36 | 727.6 | 1199.34 | 285.19 | 1224.5
VASCULAR SURGERY | 446.18 | 809.75 | 643.15 | 641.32 | 737.45 | 571.23 | 667.87 | 753.89 | 785.58 | 984.42 | 571.31 | 550.57 | 984.76
UROLOGY | 727.04 | 729.89 | 778.35 | 1076.24 | 744.62 | 1038.24 | 897.56 | 1272.68 | 1224.71 | 1004.66 | 1066.93 | 1239.36 | 1212.53
UROLOGY | 714.58 | 625.94 | 928.11 | 501.94 | 797.83 | 1062.12 | 902.08 | 1078.19 | 905.96 | 840.32 | 1069 | 622.03 | 1128.32
UROLOGY | 728.22 | 633.63 | 1040.14 | 751.96 | 767.65 | 783.39 | 583.8 | 844.66 | 783.81 | 751.94 | 963.23 | 759.12 | 903.47
UROLOGY | 863.19 | 881.33 | 1033.11 | 647.22 | 1126.56 | 1027.22 | 1047.56 | 961.62 | 947.84 | 942.44 | 901.78 | 1094.67 | 1036.93
SURGERY | 741.24 | 943.22 | 1713.38 | 910.1 | 1147.99 | 1263.55 | 902.31 | 1126.4 | 1249.94 | 1404.59 | 1054.76 | 1412.54 | 1143.1
SURGERY | 1195.48 | 1385.48 | 1132.64 | 497.21 | 1295.78 | 1061.14 | 1094.16 | 1160.39 | 1104.03 | 696.45 | 1003.85 | 1755.56 | 731.68
SURGERY | 1130.56 | 947.32 | 977.16 | 1019.25 | 946.69 | 1065.82 | 628.32 | 832.77 | 1011 | 1034.29 | 964.46 | 1230.83 | 1030.9
SURGERY | 693.65 | 715.41 | 1171.95 | 702.24 | 781.78 | 1067.85 | 843.82 | 1119.74 | 969.15 | 967.52 | 820.37 | 859.52 | 960.34
SURGERY | 58.79 | 44.19 | 28.64 | 64.89 | 29.98 | 70.15 | 43.86 | 47.15 | 20.53 | 68.76 | 44.07 | 21.22 | 32.07
SURGERY | 1120.01 | 663.51 | 1065.06 | 587.08 | 516.96 | 938.22 | 664.13 | 1110.69 | 857.92 | 796.76 | 1161.51 | 779.58 | 1161.33
SURGERY | 552.93 | 454.57 | 773.44 | 747.21 | 471.98 | 1131.14 | 324.49 | 662.18 | 849.26 | 472.47 | 712.2 | 506.12 | 561.64
Rheumatology | 360.82 | 412.65 | 635.77 | 466.94 | 458.92 | 476.1 | 349.44 | 496.18 | 474.79 | 497.59 | 488.46 | 478.36 | 456.1
Rheumatology | 377.8 | 456.91 | 487.72 | 388.96 | 335.53 | 424.99 | 393.96 | 390.15 | 410.73 | 406.23 | 422.5 | 414.29 | 402.36
Rheumatology | 240.75 | 374.69 | 332.54 | 368.29 | 260.62 | 355.4 | 274.23 | 315.18 | 305.56 | 336.57 | 379.22 | 319.98 | 336.21
PULMONOLOGY | 0 | 0 | 0 | 359.98 | 942.21 | 1061.35 | 662.02 | 976.93 | 1281.7 | 993.94 | 749.82 | 938.22 | 971.84
PULMONOLOGY | 1024.6 | 792.83 | 741.95 | 537.69 | 626.53 | 838.04 | 450.88 | 643.67 | 1083.48 | 495.47 | 701.77 | 884.73 | 532.87
PULMONOLOGY | 1910.68 | 1299.44 | 919.68 | 2164.2 | 1030.37 | 1234.65 | 1330.45 | 1003.83 | 1031.57 | 1273.93 | 1447.27 | 1406.29 | 1276.09
PULMONOLOGY | 741.75 | 1155.36 | 1036.41 | 1343.73 | 500.95 | 1072.23 | 764.09 | 509.31 | 811.66 | 974.52 | 757.69 | 1111.37 | 821.62
PULMONOLOGY | 0 | 0 | 0 | 324.23 | 663.67 | 1027.75 | 405.15 | 616 | 777.88 | 566.42 | 939.32 | 1110.43 | 797.34
PULMONOLOGY | 1270.96 | 972.1 | 697.84 | 968.24 | 575.38 | 940.43 | 628.66 | 755.29 | 653.51 | 812.59 | 910.19 | 455.23 | 666.65
PODIATRY | 260.16 | 395.41 | 365.42 | 252.96 | 277.13 | 282.83 | 237.12 | 269.15 | 230.87 | 247.24 | 332.92 | 257.67 | 233.46
PLASTIC SURGERY | 575.26 | 270.7 | 813.96 | 641.53 | 591.5 | 866.17 | 533.72 | 642.12 | 670.29 | 527.1 | 595.63 | 704.67 | 912.03
PLASTIC SURGERY | 696.47 | 779.67 | 929.43 | 371.62 | 652.2 | 696.05 | 951.19 | 723.26 | 599.72 | 675.48 | 919.49 | 727.94 | 979.9
PLASTIC SURGERY | 199.34 | 178.38 | 209.37 | 157.14 | 10.98 | 4 | 0 | 0 | 0 | -18.38 | 0 | 2 | 0
ORTHOPEDIC SURGERY | 749.71 | 875.99 | 761.33 | 826.03 | 1052.91 | 1034.15 | 1083.81 | 863.32 | 1117.93 | 730.09 | 815.05 | 981.4099999999994 | 631.73
ORTHOPEDIC SURGERY | 735.24 | 826.16 | 1009.44 | 675.5 | 868.76 | 903.09 | 567.7 | 693.28 | 868.97 | 774.57 | 950.59 | 963.86 | 658.68
ORTHOPEDIC SURGERY | 1025.95 | 639.19 | 987.69 | 923.21 | 1224.83 | 1149.93 | 826.25 | 954.99 | 822.74 | 1079.55 | 1048.23 | 898.27 | 970.68
ORTHOPEDIC SURGERY | 1019 | 545.59 | 639.26 | 503.6 | 728.65 | 795.49 | 716.05 | 821.9399999999995 | 649.52 | 612.8500000000006 | 1058.38 | 611.73 | 501.96
ORTHOPEDIC SURGERY | 536.29 | 664.68 | 770.66 | 576.66 | 770.02 | 566.82 | 469.66 | 562.95 | 519.65 | 703.88 | 488.25 | 458.77 | 596.9
ORTHOPEDIC SURGERY | 753.83 | 753.26 | 871.89 | 697.28 | 723.73 | 923.05 | 595.4299999999995 | 665.73 | 490.29 | 654.62 | 504.9 | 372.52 | 467.39
ORTHOPEDIC SURGERY | 359.65 | 908.53 | 632.09 | 453.14 | 590.03 | 530.4 | 567.36 | 556.2 | 455.78 | 480.07 | 636.02 | 362.37 | 483.18
ORTHOPEDIC SURGERY | 104.89 | 312.95 | 396.9 | 315.16 | 444.55 | 219.04 | 238.39 | 441.7 | 348.55 | 317.58 | 317.51 | 174.06 | 302.73
HAND SURGERY | 821.69 | 1205.96 | 1282.25 | 1153.83 | 643.2 | 990.59 | 800.47 | 780.96 | 679.48 | 1063.49 | 897.69 | 655.23 | 1073.3
HAND SURGERY | 591.86 | 692.68 | 676.95 | 1018.3 | 554.95 | 741.12 | 598.16 | 685.08 | 426.36 | 774.43 | 821.89 | 640.44 | 765.1
OB/GYN | 1015.32 | 1195.79 | 1178.82 | 1055.5 | 1116.29 | 1311.53 | 751.45 | 853.77 | 887.88 | 930.43 | 1180.07 | 981.84 | 821
OB/GYN | 1263.61 | 1098.5 | 1298.98 | 1103.62 | 951.91 | 1368.33 | 1075.21 | 1279.57 | 847.23 | 1081.27 | 930.22 | 1137.33 | 961.15
OB/GYN | 727.89 | 849.54 | 738.43 | 636.37 | 818.28 | 747.32 | 572.28 | 699.89 | 846.93 | 635.64 | 728.27 | 371.29 | 548.95
OB/GYN | 1210.57 | 935.24 | 931.9 | 901.85 | 743.88 | 986.68 | 496.95 | 701.05 | 686.54 | 604.86 | 576.57 | 581.31 | 684.68
OB/GYN | 396.43 | 582.47 | 614.1 | 586.08 | 689.71 | 681.96 | 595.23 | 630.3 | 647.34 | 614.82 | 951.73 | 419.54 | 739.19
OB/GYN | 800.02 | 413.78 | 681.89 | 611.96 | 859.98 | 807.32 | 666.13 | 587.72 | 626.97 | 381.39 | 686.47 | 281.84 | 259.99
OB/GYN | 773.81 | 676.45 | 470.39 | 811.71 | 491.68 | 662.25 | 393.07 | 425.61 | 436.95 | 560.81 | 728.5 | 383.09 | 522.49
OB/GYN | 0 | 0 | 0 | 113.43 | 258.7 | 434.64 | 269.27 | 296.35 | 381.33 | 400.01 | 370.06 | 593.41 | 679.62
NEURO | 620.87 | 516.69 | 615.62 | 530.26 | 635.82 | 538.01 | 495.16 | 549.66 | 644.21 | 528.05 | 562.01 | 521.94 | 320.16
NEURO | 703.76 | 554.34 | 610.41 | 464.41 | 691.71 | 700.84 | 488.75 | 601.73 | 640.7 | 346.48 | 583.61 | 604.41 | 502.62
NEURO | 636.24 | 456.13 | 730.48 | 624.16 | 484.34 | 755.7 | 600.22 | 594.72 | 546.58 | 614.3 | 753.21 | 629.59 | 554.65
NEURO | 460.32 | 472.5 | 534.73 | 393.44 | 279.01 | 553.82 | 298.07 | 678.97 | 537.3 | 382.82 | 454.63 | 471.67 | 402.55
NEURO | 593.51 | 489.04 | 666.63 | 251.59 | 570.5 | 527.35 | 520.25 | 472.11 | 508.72 | 489.92 | 638.67 | 536.89 | 563.56
NEURO | 372.73 | 465.64 | 427.09 | 455.35 | 461.09 | 423.35 | 422.46 | 383.93 | 420.01 | 358.79 | 435.12 | 509.79 | 452.11
NEPHROLOGY | 581.7 | 682.06 | 887.8 | 615.59 | 668.13 | 640.27 | 812.68 | 653.09 | 639.37 | 689.57 | 589.6 | 673.64 | 439.5
NEPHROLOGY | 569.79 | 676.45 | 655.92 | 520.57 | 741.7 | 644.74 | 472.09 | 636.71 | 602.47 | 579.49 | 832.63 | 557.88 | 660.42
NEPHROLOGY | 0 | 0 | 0 | 0 | 86.8 | 363.55 | 106.87 | 733.58 | 329.33 | 291.53 | 290.7 | 514.5 | 161.28
NEPHROLOGY | 637.43 | 556.65 | 888.42 | 667.5 | 655.71 | 718.71 | 544.26 | 385.47 | 742.46 | 631.5 | 750.15 | 851.48 | 458.81
INTERNAL MEDICINE | 497.1 | 527.08 | 522.76 | 493.08 | 503.65 | 416.7 | 452.78 | 448.8 | 652.33 | 421.62 | 546.53 | 494.34 | 471.83
INTERNAL MEDICINE | 517.42 | 383.26 | 602.44 | 408.75 | 515.04 | 597.96 | 458.74 | 570.61 | 565.43 | 467.24 | 560.67 | 422.57 | 557.43
INTERNAL MEDICINE | 462.32 | 367.58 | 432.08 | 354.02 | 427.1 | 380.78 | 445.19 | 533.6 | 556.69 | 539.15 | 661.28 | 634.36 | 436.97
INTERNAL MEDICINE | 240.56 | 264.49 | 292.12 | 361.27 | 208.2 | 339.85 | 288.65 | 179.53 | 488.09 | 298.39 | 226.98 | 214.81 | 162.37
INTERNAL MEDICINE | 442.61 | 293.99 | 273.23 | 427.69 | 374.47 | 370.91 | 476.69 | 408.8 | 472 | 479.19 | 497.04 | 388.25 | 388.43
INTERNAL MEDICINE | 423.35 | 405.84 | 567.43 | 510.32 | 448.37 | 487.65 | 369.7 | 416.19 | 461.35 | 435.38 | 612.35 | 447.2 | 332
INTERNAL MEDICINE | 450.8 | 290 | 402.82 | 500.22 | 464.66 | 394.27 | 354.86 | 303.55 | 447.31 | 304.34 | 440.19 | 390.09 | 341.09
INTERNAL MEDICINE | 447.07 | 260.97 | 360.08 | 420.49 | 479.75 | 479.05 | 404.2 | 388.76 | 439.11 | 510.63 | 361.95 | 469.12 | 502.58
INTERNAL MEDICINE | 434.3 | 326.55 | 404.88 | 392.72 | 432.1 | 454.34 | 433 | 476.41 | 433.82 | 303.93 | 441.02 | 471.84 | 376.62
INTERNAL MEDICINE | 458.99 | 393.84 | 363.18 | 356.88 | 291.35 | 382.49 | 335.1 | 362.91 | 407.02 | 318.31 | 407.52 | 374.14 | 292.63
INTERNAL MEDICINE | 301.96 | 329.85 | 217.63 | 284.02 | 273.29 | 304.68 | 290.91 | 316.4 | 398.13 | 244.27 | 334.18 | 275.3 | 306.93
INTERNAL MEDICINE | 584.5 | 483.12 | 470.01 | 539.94 | 419.47 | 455.33 | 414.17 | 485.45 | 394.81 | 325.47 | 484.6 | 537.5 | 408.04
INTERNAL MEDICINE | 415.41 | 237.98 | 419.5 | 221.3 | 333.59 | 352.36 | 297.44 | 201.63 | 388.31 | 260.1 | 359.5 | 471.27 | 348.13
INTERNAL MEDICINE | 480.89 | 328.1 | 351.84 | 365.63 | 419.76 | 390.21 | 348.43 | 289.51 | 384.27 | 395.05 | 394.1 | 449.21 | 389.76
INTERNAL MEDICINE | 390.7 | 339.3 | 336.37 | 324.31 | 334.64 | 322.45 | 308.78 | 361.36 | 368.53 | 335.76 | 477.64 | 416.06 | 519.43
INTERNAL MEDICINE | 525.79 | 443.78 | 555.39 | 483.43 | 390.51 | 407.36 | 423.02 | 445.16 | 349.83 | 343.2 | 484.35 | 309.08 | 432.23
INTERNAL MEDICINE | 271.09 | 138.47 | 372.7 | 347.01 | 383.76 | 369.17 | 278.64 | 342.73 | 195.68 | 352.09 | 391.67 | 383.24 | 247.38
GYN ONC | 1068.97 | 448.48 | 513.53 | 974.41 | 742.29 | 828.01 | 715 | 566.57 | 847.51 | 588.71 | 664.19 | 880.02 | 600.12
GENERAL PRACTICE | 324.51 | 311.98 | 386.3 | 361.24 | 250.05 | 345.2 | 337.52 | 324.4 | 328.06 | 307.06 | 393.71 | 383.98 | 314.61
GENERAL PRACTICE | 455.14 | 486.11 | 475.1 | 436.64 | 465.68 | 425.67 | 454.76 | 732.11 | 414.44 | 438.94 | 439.93 | 473.53 | 346.95
GENERAL PRACTICE | 376.65 | 329.5 | 436.14 | 352.72 | 485.77 | 448.34 | 358.96 | 439.76 | 410.87 | 366.96 | 421.16 | 396.71 | 337.99
GENERAL PRACTICE | 311.26 | 310.84 | 268.11 | 333.37 | 283.1 | 265.57 | 218.67 | 302.05 | 76.33 | 0 | 0 | 0 | 0
GASTROENTEROLOGY | 2079.89 | 1435.38 | 1573.16 | 2332.26 | 3412.05 | 406.21 | 1319.8 | 3888.27 | 969.17 | 1402.59 | 3389.79 | 15.04 | 1393.43
GASTROENTEROLOGY | 1134.38 | 1395.03 | 1030.84 | 1379.22 | 1204.61 | 1012.75 | 1512.18 | 1127.48 | 894.43 | 1103.42 | 1394.98 | 865.97 | 1214.35
GASTROENTEROLOGY | 1323.37 | 747.84 | 1577.37 | 1299.12 | 1378.43 | 893.82 | 1098.17 | 1443.26 | 775.52 | 1313.3 | 1174.38 | 960.62 | 1574.18
GASTROENTEROLOGY | 886.33 | 937.63 | 854.14 | 637.05 | 694.24 | 946.1 | 363.53 | 717.57 | 752.84 | 709.74 | 750.63 | 842.71 | 616.88
GASTROENTEROLOGY | 274.17 | 305.91 | 390.44 | 472.99 | 238.84 | 457.6 | 275.6 | 164.9 | 512.76 | 444.18 | 461.74 | 533.84 | 430.27
EAR, NOSE & THROAT | 491.3 | 739.19 | 1185.69 | 664.36 | 561.88 | 816.98 | 705.47 | 591.34 | 819.69 | 548.32 | 717.55 | 731.34 | 613.11
EAR, NOSE & THROAT | 481.78 | 667.16 | 688.63 | 520.54 | 293.43 | 685.65 | 377.04 | 616.8 | 706.22 | 615.3 | 530.85 | 706.46 | 535.51
EAR, NOSE & THROAT | 520.34 | 746.33 | 1105.92 | 562.54 | 664.21 | 600.83 | 523.06 | 840.36 | 619.54 | 416.61 | 825.11 | 824.28 | 454.2
EAR, NOSE & THROAT | 456.76 | 495.99 | 690.84 | 610.88 | 603.55 | 253.68 | 477.92 | 478.34 | 345.06 | 489.24 | 549.29 | 596.19 | 515.92
DERMATOLOGY | 269.49 | 310.94 | 343.85 | 200.15 | 338.8 | 231.45 | 283.93 | 256.56 | 237.65 | 184.19 | 302.6 | 344.73 | 237.59
DERMATOLOGY | 352.11 | 538.87 | 616.55 | 529.11 | 420.4 | 586.39 | 478.05 | 463.8 | 560.98 | 474.23 | 580.68 | 541.32 | 511.13
DERMATOLOGY | 741.2 | 498.23 | 771.93 | 562.22 | 709.56 | 743.54 | 627.56 | 619.19 | 499.62 | 655.57 | 711.2 | 600.6 | 683.19
DERMATOLOGY | 770.73 | 484.37 | 615.96 | 506.08 | 548.86 | 589.93 | 550.22 | 590.81 | 341.7 | 595.57 | 605.71 | 605.55 | 533.77
DERMATOLOGY | 296.04 | 190.26 | 216.59 | 339.41 | 328.5 | 249.32 | 272.68 | 298.94 | 251.46 | 307 | 234.69 | 332.77 | 82.88
COLO RECTAL SURGERY | 1129 | 989.36 | 1342.07 | 1062.99 | 1527.16 | 1483.78 | 1089.51 | 1383.42 | 1218.39 | 1168.57 | 1246.89 | 1192.56 | 1207.44
COLO RECTAL SURGERY | 1029.64 | 592.16 | 523.58 | 1161.68 | 563.09 | 986.21 | 245.69 | 578.86 | 945.36 | 725.46 | 399.46 | 951.82 | 807.13
COLO RECTAL SURGERY | 930.33 | 1013.47 | 1038.6 | 501.72 | 546.71 | 1079.54 | 522.04 | 831.2 | 603.4 | 626.47 | 626.03 | 705.7 | 871.87
CARDIOLOGY | 1605.9 | 1959.61 | 2292.53 | 1632.15 | 2416.81 | 1865.42 | 1682.15 | 1865.13 | 2274.89 | 1118.14 | 2263.54 | 2472.3 | 1596.33
CARDIOLOGY | 945.33 | 1571.24 | 1255.11 | 1567.36 | 1575.46 | 1186.64 | 1187.09 | 1054.64 | 1431.03 | 1427.12 | 1062.65 | 1295.47 | 880.36
CARDIOLOGY | 470.76 | 683.92 | 977.77 | 1474.63 | 464.7 | 1364.37 | 687.91 | 504.78 | 1186.01 | 880.23 | 631.57 | 1050.76 | 1110.72
CARDIOLOGY | 957.87 | 1085.09 | 1147.88 | 923.73 | 1292.08 | 881.26 | 959.97 | 1078.87 | 1168.46 | 1145.64 | 1095.31 | 1112.03 | 941.7
CARDIOLOGY | 0 | 0 | 0 | 0 | 386.19 | 541.03 | 638.96 | 1421.16 | 1086.23 | 512.35 | 800.16 | 1129.28 | 695.23
CARDIOLOGY | 1009.56 | 1125.98 | 1041.03 | 744.53 | 1268.22 | 951.4 | 1009.21 | 952.02 | 848.43 | 1146.9 | 957.55 | 1370.63 | 654.02
CARDIOLOGY | 590.88 | 993.48 | 610.69 | 990.08 | 692.9 | 840.31 | 852.15 | 715.35 | 640.97 | 804.22 | 875.65 | 516.99 | 852.84
CARDIOLOGY | 270.63 | 243.5 | 395.01 | 289.71 | 462.12 | 349.83 | 357.99 | 143.68 | 260.04 | 352.35 | 281.66 | 308.53 | 268.16
CARDIOLOGY | 341.31 | 541.91 | 554.05 | 344.86 | 552.48 | 322.23 | 329.18 | 352.84 | 241.17 | 334.8 | 367.32 | 272.24 | 306.21
CARDIO THORACIC SURGERY | 1382.12 | 1100.81 | 992.82 | 911.92 | 1266.24 | 1020.67 | 1329.72 | 833.42 | 1776.57 | 1417.01 | 1241.16 | 689.25 | 900.37
CARDIO THORACIC SURGERY | 943.47 | 824.68 | 1234.92 | 2001.86 | 2004.66 | 853.39 | 1367.75 | 1626.25 | 799.19 | 1328.11 | 1063.74 | 1562.48 | 1206.03