Spreadsheet: 881632d1729761122-count-differences-between-ranges-with-multiple-rows-and-columns-with-multiple-criteria-count-differences-between-ranges-multiple-rows-and-columns-with-multiple-criteria
Sheet: Sheet1

 |  |  | PRE-ACTIVITY MEASUREMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POST-ACTIVITY MEASUREMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected Result |  |  | Expected Result (Logic):  Count differences between ranges D6:AA36 and AE6:BB36 with the below criteria: ▪ Asset Type ▪ Location  For example, compare D8 with AE8 or M9 with AN9
 | Asset Type | ► | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 |  | Asset Type | ► | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1
 | Location | ► | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Location | ► | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Asset Type 1 | Asset Type 2
 |  |  | 808 | 812 | 823 | 823 | 828 | 829 | 827 | 827 | 826 | 828 | 825 | 827 | 824 | 828 | 829 | 828 | 819 | 824 | 822 | 823 | 824 | 825 | 815 | 810 |  |  |  | 808 | 812 | 823 | 823 | 828 | 829 | 827 | 827 | 826 | 828 | 825 | 827 | 824 | 828 | 829 | 828 | 819 | 824 | 822 | 823 | 824 | 825 | 815 | 810
 |  |  | 820 | 820 | 811 | 811 | 818 | 822 | 824 | 823 | 827 | 825 | 822 | 821 | 827 | 827 | 826 | 826 | 825 | 826 | 824 | 820 | 817 | 815 | 825 | 822 |  |  |  | 820 | 820 | 811 | 811 | 818 | 822 | 824 | 823 | 827 | 825 | 822 | 821 | 827 | 827 | 826 | 826 | 825 | 826 | 824 | 820 | 817 | 815 | 825 | 822
 |  |  | 815 | 821 | 830 | 830 | 837 | 839 | 839 | 838 | 836 | 837 | 838 | 834 | 837 | 838 | 838 | 835 | 837 | 835 | 837 | 837 | 838 | 837 | 828 | 823 |  |  |  | 815 | 821 | 830 | 830 | 837 | 839 | 839 | 838 | 836 | 837 | 838 | 834 | 837 | 838 | 838 | 835 | 837 | 835 | 837 | 837 | 838 | 837 | 828 | 823
 |  |  | 826 | 828 | 829 | 827 | 824 | 829 | 829 | 828 | 831 | 834 | 834 | 834 | 831 | 834 | 833 | 830 | 826 | 829 | 831 | 829 | 825 | 825 | 836 | 835 |  |  |  | 826 | 828 | 829 | 827 | 824 | 829 | 829 | 828 | 831 | 834 | 834 | 834 | 831 | 834 | 833 | 830 | 826 | 829 | 831 | 829 | 825 | 825 | 836 | 835
 |  |  | 802 | 808 | 817 | 817 | 821 | 822 | 821 | 820 | 822 | 822 | 821 | 822 | 816 | 820 | 819 | 820 | 812 | 816 | 816 | 815 | 809 | 809 | 818 | 818 |  |  |  | 830 | 830 | 817 | 817 | 835 | 822 | 821 | 820 | 822 | 822 | 821 | 822 | 816 | 820 | 819 | 820 | 812 | 816 | 816 | 815 | 809 | 809 | 818 | 818 |  | 2 | 1
 |  |  | 815 | 819 | 830 | 830 | 836 | 837 | 836 | 835 | 834 | 836 | 835 | 838 | 835 | 838 | 834 | 833 | 837 | 838 | 838 | 833 | 828 | 827 | 819 | 820 |  |  |  | 815 | 819 | 830 | 830 | 836 | 837 | 836 | 835 | 834 | 836 | 835 | 838 | 835 | 838 | 834 | 833 | 837 | 838 | 838 | 833 | 828 | 827 | 819 | 820
 |  |  | 848 | 850 | 845 | 841 | 836 | 834 | 830 | 832 | 834 | 836 | 835 | 836 | 836 | 837 | 833 | 837 | 835 | 834 | 834 | 838 | 842 | 848 | 849 | 849 |  |  |  | 848 | 850 | 845 | 841 | 836 | 834 | 830 | 832 | 834 | 836 | 835 | 836 | 836 | 837 | 833 | 837 | 835 | 834 | 834 | 838 | 842 | 848 | 849 | 849
 |  |  | 817 | 822 | 830 | 832 | 833 | 830 | 833 | 836 | 840 | 838 | 836 | 836 | 835 | 837 | 834 | 835 | 834 | 836 | 835 | 832 | 833 | 832 | 827 | 823 |  |  |  | 817 | 822 | 830 | 832 | 833 | 830 | 833 | 836 | 840 | 838 | 836 | 836 | 835 | 837 | 834 | 835 | 834 | 836 | 835 | 832 | 833 | 832 | 827 | 823
 |  |  | 823 | 823 | 812 | 812 | 818 | 824 | 824 | 824 | 823 | 825 | 828 | 825 | 828 | 828 | 828 | 828 | 824 | 825 | 828 | 828 | 825 | 825 | 815 | 810 |  |  |  | 823 | 823 | 812 | 812 | 818 | 824 | 824 | 824 | 823 | 825 | 828 | 825 | 828 | 828 | 828 | 828 | 824 | 825 | 828 | 828 | 825 | 825 | 815 | 810
 |  |  | 827 | 829 | 831 | 831 | 831 | 832 | 828 | 833 | 836 | 836 | 838 | 837 | 838 | 838 | 837 | 838 | 836 | 837 | 832 | 835 | 834 | 835 | 837 | 836 |  |  |  | 827 | 829 | 831 | 831 | 831 | 832 | 828 | 833 | 836 | 836 | 838 | 837 | 838 | 838 | 837 | 838 | 836 | 837 | 832 | 835 | 834 | 835 | 837 | 836
 |  |  | 829 | 833 | 834 | 835 | 837 | 836 | 836 | 836 | 835 | 831 | 829 | 829 | 834 | 839 | 839 | 838 | 834 | 836 | 836 | 835 | 838 | 838 | 829 | 823 |  |  |  | 829 | 833 | 834 | 835 | 837 | 836 | 836 | 836 | 835 | 831 | 829 | 829 | 834 | 839 | 839 | 838 | 834 | 836 | 836 | 835 | 838 | 838 | 829 | 823
 |  |  | 799 | 802 | 814 | 814 | 820 | 825 | 820 | 821 | 823 | 828 | 822 | 828 | 827 | 830 | 828 | 828 | 820 | 826 | 824 | 823 | 818 | 823 | 820 | 815 |  |  |  | 827 | 827 | 814 | 814 | 820 | 825 | 820 | 821 | 823 | 828 | 822 | 828 | 827 | 830 | 828 | 828 | 820 | 826 | 824 | 823 | 818 | 823 | 820 | 815 |  | 2
 |  |  | 833 | 827 | 838 | 837 | 841 | 840 | 840 | 841 | 837 | 841 | 841 | 841 | 833 | 835 | 836 | 833 | 841 | 841 | 841 | 841 | 837 | 840 | 832 | 831 |  |  |  | 833 | 827 | 838 | 837 | 841 | 840 | 840 | 841 | 837 | 841 | 841 | 841 | 833 | 835 | 836 | 833 | 841 | 841 | 841 | 841 | 837 | 840 | 832 | 831
 |  |  | 827 | 822 | 831 | 831 | 838 | 839 | 841 | 839 | 835 | 837 | 838 | 836 | 840 | 839 | 839 | 839 | 838 | 839 | 839 | 839 | 832 | 832 | 841 | 841 |  |  |  | 827 | 822 | 831 | 831 | 838 | 839 | 841 | 839 | 835 | 837 | 838 | 836 | 840 | 839 | 839 | 839 | 838 | 839 | 839 | 839 | 832 | 832 | 841 | 841
 |  |  | 816 | 820 | 831 | 831 | 838 | 842 | 843 | 842 | 838 | 837 | 839 | 839 | 838 | 835 | 837 | 837 | 837 | 836 | 838 | 836 | 829 | 829 | 820 | 814 |  |  |  | 816 | 820 | 831 | 831 | 838 | 842 | 843 | 842 | 838 | 837 | 839 | 839 | 838 | 835 | 837 | 837 | 837 | 836 | 838 | 836 | 829 | 829 | 820 | 814
 |  |  | 806 | 811 | 821 | 821 | 827 | 826 | 826 | 827 | 827 | 827 | 827 | 827 | 823 | 827 | 825 | 827 | 821 | 823 | 823 | 817 | 810 | 810 | 800 | 795 |  |  |  | 806 | 811 | 821 | 821 | 827 | 826 | 826 | 827 | 827 | 827 | 827 | 827 | 823 | 827 | 825 | 827 | 821 | 823 | 823 | 817 | 810 | 810 | 823 | 823 |  | 2
 |  |  | 828 | 825 | 830 | 836 | 836 | 836 | 837 | 832 | 838 | 838 | 836 | 840 | 841 | 837 | 842 | 842 | 841 | 836 | 841 | 837 | 836 | 834 | 830 | 834 |  |  |  | 828 | 825 | 830 | 836 | 836 | 836 | 837 | 832 | 838 | 838 | 836 | 840 | 841 | 837 | 842 | 842 | 841 | 836 | 841 | 837 | 836 | 834 | 830 | 834
 |  |  | 835 | 838 | 844 | 844 | 845 | 843 | 847 | 845 | 847 | 846 | 845 | 847 | 846 | 847 | 846 | 848 | 839 | 843 | 845 | 845 | 842 | 840 | 832 | 832 |  |  |  | 835 | 838 | 844 | 844 | 845 | 843 | 847 | 845 | 847 | 850 | 850 | 847 | 846 | 847 | 846 | 848 | 839 | 843 | 845 | 845 | 842 | 840 | 832 | 832 |  |  | 2
 |  |  | 804 | 810 | 819 | 819 | 826 | 832 | 832 | 832 | 834 | 829 | 834 | 834 | 832 | 831 | 827 | 832 | 834 | 835 | 829 | 829 | 822 | 822 | 812 | 807 |  |  |  | 804 | 810 | 819 | 819 | 826 | 832 | 832 | 832 | 834 | 829 | 834 | 834 | 832 | 831 | 827 | 832 | 834 | 835 | 829 | 829 | 822 | 822 | 812 | 807
 |  |  | 804 | 809 | 819 | 819 | 826 | 831 | 832 | 832 | 833 | 833 | 833 | 833 | 833 | 833 | 834 | 834 | 832 | 833 | 832 | 829 | 822 | 823 | 831 | 827 |  |  |  | 804 | 809 | 819 | 819 | 826 | 831 | 832 | 832 | 833 | 833 | 833 | 833 | 833 | 833 | 834 | 834 | 832 | 833 | 832 | 829 | 822 | 823 | 831 | 827
 |  |  | 820 | 821 | 826 | 823 | 830 | 830 | 829 | 830 | 832 | 832 | 833 | 832 | 833 | 832 | 833 | 833 | 829 | 831 | 832 | 828 | 832 | 832 | 827 | 828 |  |  |  | 820 | 821 | 826 | 823 | 830 | 830 | 829 | 830 | 832 | 832 | 833 | 832 | 833 | 832 | 833 | 833 | 829 | 831 | 832 | 828 | 832 | 832 | 827 | 828
 |  |  | 822 | 820 | 829 | 832 | 836 | 835 | 836 | 835 | 839 | 838 | 837 | 836 | 836 | 834 | 836 | 835 | 836 | 837 | 837 | 831 | 824 | 824 | 814 | 809 |  |  |  | 822 | 820 | 829 | 832 | 836 | 835 | 836 | 835 | 839 | 838 | 837 | 836 | 836 | 834 | 836 | 835 | 836 | 837 | 837 | 831 | 824 | 824 | 814 | 809
 |  |  | 815 | 821 | 829 | 828 | 828 | 829 | 828 | 827 | 835 | 833 | 833 | 831 | 833 | 832 | 831 | 831 | 833 | 831 | 832 | 834 | 830 | 828 | 821 | 816 |  |  |  | 815 | 821 | 829 | 828 | 828 | 829 | 828 | 827 | 835 | 833 | 833 | 831 | 833 | 832 | 831 | 831 | 833 | 831 | 832 | 834 | 830 | 828 | 821 | 816
 |  |  | 827 | 827 | 837 | 838 | 842 | 843 | 841 | 843 | 843 | 840 | 844 | 841 | 842 | 840 | 841 | 841 | 841 | 840 | 842 | 839 | 836 | 838 | 834 | 834 |  |  |  | 827 | 827 | 837 | 838 | 842 | 843 | 841 | 843 | 843 | 840 | 844 | 841 | 842 | 840 | 841 | 841 | 841 | 840 | 842 | 839 | 836 | 838 | 834 | 834
 |  |  | 813 | 819 | 826 | 826 | 823 | 822 | 822 | 818 | 825 | 826 | 823 | 825 | 824 | 824 | 821 | 822 | 821 | 824 | 820 | 821 | 814 | 814 | 805 | 800 |  |  |  | 813 | 819 | 826 | 826 | 823 | 822 | 822 | 818 | 825 | 826 | 823 | 825 | 824 | 824 | 821 | 822 | 821 | 824 | 820 | 821 | 814 | 814 | 827 | 827 |  | 2
 |  |  | 827 | 827 | 838 | 839 | 838 | 838 | 835 | 838 | 838 | 840 | 842 | 838 | 838 | 841 | 839 | 836 | 840 | 839 | 835 | 839 | 835 | 839 | 833 | 830 |  |  |  | 827 | 827 | 838 | 839 | 838 | 838 | 835 | 838 | 838 | 840 | 842 | 838 | 838 | 841 | 839 | 836 | 840 | 839 | 835 | 839 | 835 | 839 | 833 | 830
 |  |  | 824 | 824 | 814 | 814 | 820 | 826 | 825 | 826 | 829 | 828 | 826 | 827 | 828 | 826 | 827 | 823 | 823 | 825 | 825 | 819 | 812 | 815 | 823 | 823 |  |  |  | 824 | 824 | 814 | 814 | 820 | 826 | 825 | 826 | 829 | 828 | 826 | 827 | 828 | 826 | 827 | 823 | 823 | 825 | 825 | 819 | 812 | 815 | 823 | 823
 |  |  | 820 | 820 | 810 | 809 | 816 | 822 | 822 | 822 | 823 | 824 | 825 | 823 | 820 | 821 | 819 | 818 | 820 | 821 | 821 | 815 | 809 | 809 | 820 | 820 |  |  |  | 820 | 820 | 810 | 809 | 816 | 822 | 822 | 822 | 823 | 824 | 825 | 823 | 820 | 821 | 819 | 818 | 820 | 821 | 821 | 815 | 809 | 809 | 820 | 820
 |  |  | 808 | 814 | 823 | 823 | 823 | 823 | 817 | 819 | 827 | 827 | 827 | 827 | 826 | 825 | 826 | 827 | 826 | 827 | 826 | 825 | 824 | 824 | 815 | 809 |  |  |  | 808 | 814 | 823 | 823 | 823 | 823 | 817 | 819 | 827 | 827 | 827 | 827 | 826 | 825 | 826 | 827 | 826 | 827 | 826 | 825 | 824 | 824 | 815 | 809