Spreadsheet: 875868d1722500825-average-range-with-multiple-columns-and-rows-with-multiple-criteria-average-ifs-multiple-columns-and-rows
Sheet: Sheet1

 |  |  | DAILY MILEAGE
 | Start |  | Asset # | [NAME] | 2024-05-12 00:00:00 | 2024-05-13 00:00:00 | 2024-05-14 00:00:00 | 2024-05-15 00:00:00 | 2024-05-16 00:00:00 | 2024-05-17 00:00:00 | 2024-05-18 00:00:00 | 2024-05-19 00:00:00 | 2024-05-20 00:00:00 | 2024-05-21 00:00:00 | 2024-05-22 00:00:00 | 2024-05-23 00:00:00 | 2024-05-24 00:00:00 | 2024-05-25 00:00:00 | 2024-05-26 00:00:00 | 2024-05-27 00:00:00 | 2024-05-28 00:00:00 | 2024-05-29 00:00:00 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-01 00:00:00 | 2024-06-02 00:00:00 | 2024-06-03 00:00:00 | 2024-06-04 00:00:00 | 2024-06-05 00:00:00 | 2024-06-06 00:00:00 | 2024-06-07 00:00:00 | 2024-06-08 00:00:00 | 2024-06-09 00:00:00 | 2024-06-10 00:00:00 | 2024-06-11 00:00:00 | 2024-06-12 00:00:00 | 2024-06-13 00:00:00 | 2024-06-14 00:00:00 | 2024-06-15 00:00:00 | 2024-06-16 00:00:00 | 2024-06-17 00:00:00 | 2024-06-18 00:00:00 | 2024-06-19 00:00:00 | 2024-06-20 00:00:00 | 2024-06-21 00:00:00 | 2024-06-22 00:00:00 | 2024-06-23 00:00:00 | 2024-06-24 00:00:00 | 2024-06-25 00:00:00 | 2024-06-26 00:00:00 | 2024-06-27 00:00:00 | 2024-06-28 00:00:00 | 2024-06-29 00:00:00 | 2024-06-30 00:00:00 | 2024-07-01 00:00:00 | 2024-07-02 00:00:00 | 2024-07-03 00:00:00 | 2024-07-04 00:00:00 | 2024-07-05 00:00:00 | 2024-07-06 00:00:00 | 2024-07-07 00:00:00 | 2024-07-08 00:00:00 | 2024-07-09 00:00:00 | 2024-07-10 00:00:00 | 2024-07-11 00:00:00 | 2024-07-12 00:00:00 | 2024-07-13 00:00:00 | 2024-07-14 00:00:00 | 2024-07-15 00:00:00 | 2024-07-16 00:00:00 | 2024-07-17 00:00:00 | 2024-07-18 00:00:00 | 2024-07-19 00:00:00 | 2024-07-20 00:00:00 | 2024-07-21 00:00:00 | 2024-07-22 00:00:00 | 2024-07-23 00:00:00 | 2024-07-24 00:00:00 | 2024-07-25 00:00:00 | 2024-07-26 00:00:00 | 2024-07-27 00:00:00 | 2024-07-28 00:00:00 | 2024-07-29 00:00:00 | 2024-07-30 00:00:00 | 2024-07-31 00:00:00
 |  |  | Asset 1 | 7-Type | 0 | 1811 | 1284 | 955 | 0 | 1272 | 844 | 622 | 1273 | 0 | 1910 | 1261 | 1026 | 1127 | 618 | 0 | 1291 | 2 | 1291 | 1016 | 0 | 0 | 1026 | 1026 | 1290 | 1026 | 0 | 1959 | 622 | 1015 | 1284 | 1015 | 955 | 0 | 854 | 621 | 1264 | 1019 | 1263 | 955 | 1283 | 854 | 0 | 1272 | 1284 | 955 | 1272 | 0 | 0 | 0 | 0 | 684 | 0 | 2284 | 955 | 0 | 0 | 1556 | 0 | 993 | 0 | 290 | 796 | 463 | 1284 | 1026 | 519 | 0 | 1051 | 265 | 0 | 565 | 1271 | 1271 | 1015 | 1271 | 928 | 666 | 1263 | 955 | 1018
 | 2024-05-15 00:00:00 |  | Asset 2 | 7-Type | 0 | 951 | 0 | 2289 | 1272 | 1006 | 69 | 0 | 0 | 0 | 2522 | 1015 | 1284 | 0 | 607 | 1015 | 1294 | 1005 | 1294 | 955 | 1050 | 0 | 758 | 955 | 1188 | 1188 | 684 | 464 | 0 | 1283 | 1015 | 1283 | 1284 | 1026 | 1124 | 463 | 955 | 0 | 1280 | 1019 | 1263 | 0 | 0 | 1002 | 1272 | 1001 | 754 | 626 | 796 | 463 | 1015 | 1270 | 0 | 2238 | 1026 | 1124 | 0 | 1728 | 993 | 1004 | 993 | 993 | 854 | 621 | 1026 | 1291 | 955 | 1291 | 955 | 0 | 463 | 1284 | 883 | 955 | 1284 | 1026 | 0 | 0 | 1291 | 1019 | 1262
 |  |  | Asset 3 | 7-Type | 0 | 0 | 1890 | 1052 | 1005 | 1284 | 0 | 798 | 1270 | 0 | 2285 | 351 | 1271 | 1008 | 463 | 1294 | 0 | 1291 | 1005 | 1262 | 1039 | 0 | 0 | 1291 | 1026 | 1291 | 1016 | 0 | 819 | 0 | 1283 | 1284 | 1015 | 1283 | 796 | 0 | 1280 | 1263 | 0 | 1208 | 1026 | 725 | 0 | 955 | 1284 | 1005 | 1284 | 141 | 1124 | 621 | 1283 | 1015 | 0 | 2225 | 1283 | 260 | 0 | 0 | 1004 | 1283 | 1004 | 1015 | 1124 | 0 | 260 | 1188 | 1291 | 1026 | 1026 | 854 | 618 | 1283 | 959 | 1284 | 955 | 1284 | 916 | 692 | 1019 | 1264 | 955
 | End |  | Asset 4 | 7-Type | 621 | 1272 | 1005 | 1272 | 1284 | 998 | 1024 | 622 | 1015 | 0 | 2255 | 1270 | 955 | 1123 | 0 | 1272 | 1005 | 1294 | 955 | 1291 | 907 | 0 | 1200 | 1188 | 0 | 855 | 1291 | 673 | 622 | 1284 | 955 | 0 | 1283 | 1284 | 0 | 618 | 1019 | 1280 | 947 | 1263 | 899 | 71 | 0 | 1284 | 676 | 1272 | 698 | 0 | 909 | 618 | 1270 | 955 | 0 | 2297 | 1264 | 785 | 0 | 1128 | 1211 | 955 | 1283 | 823 | 854 | 618 | 955 | 0 | 1026 | 1188 | 1188 | 866 | 614 | 40 | 1284 | 1015 | 1271 | 955 | 1029 | 681 | 955 | 1290 | 1291
 |  |  | Asset 5 | 5-Type | 9561 | 749 | 1190 | 754 | 802 | 976 | 881 | 804 | 0 | 0 | 0 | 860 | 1119 | 1047 | 717 | 1013 | 586 | 1178 | 1206 | 1046 | 610 | 781 | 873 | 1039 | 555 | 859 | 881 | 740 | 702 | 764 | 937 | 1109 | 743 | 0 | 1064 | 852 | 859 | 556 | 860 | 810 | 1065 | 1008 | 0 | 991 | 802 | 1145 | 873 | 801 | 1134 | 870 | 996 | 1079 | 0 | 1934 | 1145 | 1127 | 0 | 1354 | 1053 | 1127 | 968 | 862 | 1210 | 676 | 1074 | 873 | 1134 | 743 | 322 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 873
 | 2024-07-05 00:00:00 |  | Asset 6 | 5-Type | 516 | 1262 | 802 | 808 | 860 | 1079 | 881 | 804 | 426 | 0 | 2346 | 1074 | 0 | 913 | 499 | 976 | 1046 | 1011 | 1086 | 1086 | 799 | 610 | 1056 | 660 | 984 | 1039 | 1026 | 818 | 760 | 791 | 976 | 556 | 1074 | 1079 | 1035 | 963 | 556 | 749 | 1009 | 0 | 1128 | 1210 | 245 | 1056 | 1198 | 0 | 772 | 796 | 734 | 1173 | 874 | 1056 | 0 | 1401 | 749 | 1123 | 0 | 1731 | 1145 | 1069 | 991 | 1035 | 796 | 745 | 859 | 1022 | 859 | 1134 | 982 | 1086 | 1 | 1055 | 1145 | 1074 | 1022 | 1250 | 877 | 0 | 1079 | 0 | 436
 |  |  | Asset 7 | 5-Type | 840 | 791 | 976 | 426 | 1058 | 1056 | 0 | 0 | 872 | 0 | 1410 | 749 | 991 | 1065 | 707 | 860 | 1143 | 984 | 1011 | 756 | 0 | 365 | 848 | 1056 | 1056 | 1056 | 660 | 704 | 0 | 976 | 1010 | 873 | 0 | 1127 | 735 | 870 | 1065 | 1003 | 938 | 1010 | 1099 | 913 | 0 | 1065 | 1154 | 114 | 1074 | 1187 | 796 | 676 | 749 | 1154 | 0 | 1814 | 802 | 1134 | 0 | 1543 | 671 | 0 | 886 | 1127 | 824 | 770 | 302 | 1138 | 1145 | 0 | 1085 | 1008 | 529 | 984 | 1010 | 1075 | 1145 | 1057 | 452 | 530 | 873 | 1341 | 749
 |  |  | Asset 8 | 5-Type | 645 | 1065 | 788 | 1084 | 1013 | 1074 | 819 | 653 | 1096 | 0 | 2112 | 1056 | 1056 | 796 | 840 | 955 | 1086 | 886 | 827 | 732 | 242 | 802 | 749 | 1065 | 1165 | 0 | 1028 | 980 | 662 | 860 | 1155 | 426 | 984 | 802 | 1264 | 529 | 984 | 1210 | 687 | 856 | 894 | 796 | 425 | 1079 | 764 | 1044 | 1073 | 177 | 0 | 670 | 952 | 873 | 0 | 1870 | 1127 | 735 | 0 | 1859 | 831 | 1145 | 0 | 1010 | 1123 | 346 | 0 | 0 | 0 | 859 | 0 | 929 | 790 | 991 | 1000 | 0 | 655 | 984 | 819 | 0 | 791 | 1327 | 0
 |  |  | Asset 9 | 5-Type | 745 | 1055 | 1065 | 860 | 16 | 0 | 881 | 793 | 1079 | 0 | 1630 | 0 | 0 | 0 | 0 | 1011 | 1020 | 0 | 0 | 1887 | 1014 | 650 | 1055 | 1145 | 346 | 984 | 1134 | 759 | 820 | 1079 | 749 | 1065 | 536 | 1010 | 734 | 745 | 785 | 1036 | 980 | 0 | 655 | 1243 | 156 | 1022 | 1085 | 859 | 1127 | 614 | 1123 | 468 | 667 | 1199 | 0 | 655 | 0 | 1820 | 0 | 1375 | 886 | 1114 | 1114 | 0 | 992 | 1052 | 1145 | 531 | 1046 | 860 | 1040 | 1032 | 745 | 738 | 920 | 976 | 1079 | 1010 | 157 | 759 | 1145 | 316 | 1026
 | Average 5-Type |  | Asset 10 | 5-Type | 769 | 860 | 1034 | 1011 | 1192 | 740 | 711 | 790 | 1013 | 0 | 1778 | 0 | 1128 | 990 | 346 | 791 | 732 | 1236 | 1110 | 603 | 830 | 0 | 0 | 0 | 0 | 555 | 1526 | 434 | 752 | 859 | 797 | 976 | 1075 | 1145 | 936 | 721 | 797 | 743 | 1181 | 1055 | 937 | 1007 | 0 | 1127 | 743 | 1022 | 0 | 1127 | 735 | 0 | 528 | 764 | 0 | 1824 | 976 | 1008 | 0 | 1790 | 750 | 1065 | 789 | 1065 | 542 | 0 | 1127 | 937 | 1005 | 1085 | 525 | 860 | 402 | 791 | 946 | 1010 | 1052 | 0 | 1056 | 831 | 743 | 1388 | 789
 | Average 7-Type