Spreadsheet: 843126d1695071123-help-with-formula-for-countiifs-index-match-multiple-criteria-same-column-countif_index_match
Sheet: Example

 |  |  |  | (TX, English, 3) | (TX, Spanish, 3) | (NV, English, 3) | (NV, Spanish, 3) | <-------- I want to update the formula so all variations are accounted for in one formula.
Headers | Values | Criteria |  | Original# | Added #1 | Added #2 | Added #3 | Total
Start date | 2023-06-19 00:00:00 | Green |  |  |  |  |  |  | <-------- I want to update the formula to Countif of additional values are added.
End date | 2023-09-15 00:00:00 | Red
Start time | 00:00:00 | Total
End time | 23:59:59
States | TX | NV | <> | <> | <> | <------ The Countif Index Match formula matches column headers and counts the number of values in the column.
Cities | <> | <> | <> | <> | <>
Languages | English | Spanish | <> | <> | <>
Cars | <> | <> | <> | <> | <>
Planets | <> | <> | <> | <> | <>
Animals | <> | <> | <> | <> | <>
Vegetables | <> | <> | <> | <> | <>
Count | 3 | <> | <> | <> | <>
Date | Time | States | Cities | Languages | Cars | Planets | Animals | Vegetables | Count | Color
2023-06-19 00:00:00 | 22:00:36 | TX | Houston | English | Toyota | Earth | Cat | Carrots | 1 | Green
2023-06-19 00:00:00 | 22:08:06 | NV | Las Vegas | Spanish | Ford | Mars | Dog | Broccoli | 2 | Red
2023-06-19 00:00:00 | 23:39:45 | TX | Houston | French | Honda | Jupiter | Bird | Spinach | 3 | Green
2023-06-19 00:00:00 | 00:59:54 | NV | Las Vegas | English | Toyota | Jupiter | Hamster | Tomatoes | 4 | Red
2023-06-19 00:00:00 | 01:11:39 | TX | Houston | Spanish | Ford | Earth | Cat | Cucumbers | 5 | Green
2023-06-19 00:00:00 | 01:29:21 | NV | Las Vegas | French | Honda | Mars | Dog | Bell Peppers | 6 | Red
2023-06-19 00:00:00 | 01:46:32 | TX | Houston | English | Toyota | Jupiter | Bird | Lettuce | 7 | Green
2023-06-19 00:00:00 | 01:53:26 | NV | Las Vegas | Spanish | Ford | Jupiter | Hamster | [NAME] | None | Red
2023-06-19 00:00:00 | 01:57:49 | TX | Houston | French | Honda | Earth | Cat | Carrots | 1 | Green
2023-06-19 00:00:00 | 02:00:01 | NV | Las Vegas | English | Toyota | Mars | Dog | Broccoli | 2 | Red
2023-06-19 00:00:00 | 02:01:01 | TX | Houston | Spanish | Ford | Jupiter | Bird | Spinach | 3 | Green
2023-06-19 00:00:00 | 02:03:38 | NV | Las Vegas | French | Honda | Jupiter | Hamster | Tomatoes | 4 | Red
2023-06-19 00:00:00 | 02:18:46 | TX | Houston | English | Toyota | Earth | Cat | Cucumbers | 1 | Green
2023-06-19 00:00:00 | 02:27:20 | NV | Las Vegas | Spanish | Ford | Mars | Dog | Bell Peppers | 2 | Red
2023-06-19 00:00:00 | 02:30:50 | TX | Houston | French | Honda | Jupiter | Bird | Lettuce | 3 | Green
2023-06-19 00:00:00 | 02:31:01 | NV | Las Vegas | English | Toyota | Jupiter | Hamster | [NAME] | 4 | Red
2023-06-20 00:00:00 | 02:55:27 | TX | Houston | Spanish | Ford | Earth | Cat | Carrots | 5 | Green
2023-06-20 00:00:00 | 02:56:33 | NV | Las Vegas | French | Honda | Mars | Dog | Broccoli | 1 | Red
2023-06-20 00:00:00 | 03:00:16 | TX | Houston | English | Toyota | Jupiter | Bird | Spinach | 2 | Green
2023-06-20 00:00:00 | 03:07:51 | NV | Las Vegas | Spanish | Ford | Jupiter | Hamster | Tomatoes | 3 | Red
2023-06-20 00:00:00 | 03:09:10 | TX | Houston | French | Honda | Earth | Cat | Cucumbers | 4 | Green
2023-06-20 00:00:00 | 03:18:21 | NV | Las Vegas | English | Toyota | Mars | Dog | Bell Peppers | 5 | Red
2023-06-20 00:00:00 | 03:19:09 | TX | Houston | Spanish | Ford | Jupiter | Bird | Lettuce | 6 | Green
2023-06-20 00:00:00 | 03:20:24 | TX | Houston | French | Honda | Jupiter | Hamster | [NAME] | 7 | Red
2023-06-20 00:00:00 | 03:22:46 | TX | Houston | English | Toyota | Earth | Cat | Carrots | None | Red
2023-06-20 00:00:00 | 03:24:13 | TX | Houston | Spanish | Ford | Mars | Dog | Tomatoes | 1 | Red
2023-06-20 00:00:00 | 03:26:03 | TX | Houston | French | Toyota | Jupiter | Hamster | Cucumbers | 2 | Green
2023-06-20 00:00:00 | 03:52:09 | TX | Houston | English | Ford | Earth | Cat | Bell Peppers | 3 | Red
2023-06-20 00:00:00 | 04:04:09 | TX | Houston | Spanish | Honda | Mars | Dog | Lettuce | 4 | Red
2023-06-20 00:00:00 | 04:08:03 | TX | Houston | French | Toyota | Earth | Cat | [NAME] | 5 | Red
2023-06-20 00:00:00 | 04:17:23 | TX | Houston | English | Ford | Mars | Dog | Carrots | 6 | Green
2023-06-20 00:00:00 | 04:20:17 | TX | Houston | English | Honda | Jupiter | Bird | Tomatoes | 7 | Red
2023-06-20 00:00:00 | 04:20:45 | TX | Houston | Spanish | Toyota | Jupiter | Hamster | Cucumbers | None | Red
2023-06-20 00:00:00 | 04:36:44 | TX | Houston | French | Ford | Earth | Cat | Bell Peppers | 1 | Red
2023-06-20 00:00:00 | 04:44:11 | NV | Las Vegas | English | Toyota | Mars | Dog | Lettuce | 5 | Red
2023-06-20 00:00:00 | 04:44:35 | TX | Houston | Spanish | Ford | Jupiter | Hamster | [NAME] | 4 | Green
2023-06-20 00:00:00 | 04:45:03 | TX | Houston | French | Honda | Earth | Cat | Carrots | 7 | Red
2023-06-21 00:00:00 | 04:47:24 | TX | Houston | English | Toyota | Mars | Dog | Tomatoes | 6 | Red
2023-06-22 00:00:00 | 04:58:00 | TX | Houston | English | Ford | Earth | Cat | Cucumbers | 3 | Green
2023-06-23 00:00:00 | 05:00:03 | TX | Houston | Spanish | Honda | Mars | Dog | Bell Peppers | 2 | Green
2023-06-24 00:00:00 | 05:05:59 | NV | Las Vegas | French | Toyota | Jupiter | Bird | Lettuce | 5 | Green
2023-06-25 00:00:00 | 05:07:30 | NV | Las Vegas | English | Ford | Jupiter | Hamster | [NAME] | 4 | Green
2023-06-26 00:00:00 | 05:27:42 | TX | Houston | Spanish | Honda | Earth | Cat | Carrots | 1 | Red
2023-06-27 00:00:00 | 05:38:33 | TX | Houston | French | Toyota | Mars | Dog | Tomatoes | 7 | Red
2023-06-28 00:00:00 | 05:48:18 | TX | Houston | English | Ford | Jupiter | Hamster | Cucumbers | 5 | Red
2023-06-29 00:00:00 | 05:54:02 | TX | Houston | English | Honda | Earth | Cat | Bell Peppers | 6 | Green
2023-06-30 00:00:00 | 06:03:59 | TX | Houston | Spanish | Toyota | Mars | Dog | Lettuce | 3 | Red
2023-07-01 00:00:00 | 06:04:46 | TX | Houston | French | Ford | Earth | Cat | [NAME] | None | Green
2023-07-02 00:00:00 | 06:07:24 | TX | Houston | English | Honda | Mars | Dog | Carrots | 1 | Red
2023-07-03 00:00:00 | 06:10:36 | TX | Houston | English | Toyota | Jupiter | Bird | Carrots | 5 | Green
2023-07-04 00:00:00 | 06:14:43 | TX | Houston | English | Ford | Jupiter | Hamster | Broccoli | 4 | Red
2023-07-05 00:00:00 | 06:17:53 | TX | Houston | Spanish | Honda | Earth | Cat | Spinach | 7 | Green
2023-07-06 00:00:00 | 06:45:35 | TX | Houston | French | Toyota | Mars | Dog | Tomatoes | 6 | Red
2023-07-07 00:00:00 | 07:02:17 | TX | Houston | English | Ford | Jupiter | Hamster | Cucumbers | 4 | Green
2023-07-08 00:00:00 | 07:11:02 | TX | Houston | English | Honda | Earth | Cat | Bell Peppers | 5 | Red
2023-07-09 00:00:00 | 07:28:24 | NV | Las Vegas | English | Toyota | Mars | Dog | Lettuce | 6 | Green
2023-07-10 00:00:00 | 07:33:59 | NV | Las Vegas | Spanish | Ford | Earth | Cat | [NAME] | 7 | Red
2023-07-11 00:00:00 | 07:36:27 | NV | Las Vegas | French | Honda | Mars | Dog | Carrots | None | Green
2023-07-12 00:00:00 | 07:48:35 | NV | Las Vegas | English | Toyota | Jupiter | Bird | Broccoli | 2 | Red
2023-07-13 00:00:00 | 08:02:04 | NV | Las Vegas | English | Ford | Jupiter | Hamster | Spinach | 3 | Green
2023-07-14 00:00:00 | 08:04:50 | NV | Las Vegas | English | Honda | Earth | Cat | Tomatoes | 4 | Red
2023-07-15 00:00:00 | 08:06:04 | NV | Las Vegas | Spanish | Toyota | Mars | Dog | Cucumbers | 1 | Green
2023-07-16 00:00:00 | 08:06:25 | NV | Las Vegas | French | Ford | Jupiter | Hamster | Carrots | 2 | Red
2023-07-17 00:00:00 | 08:10:20 | NV | Las Vegas | English | Honda | Earth | Cat | Broccoli | 3 | Green
2023-07-18 00:00:00 | 08:13:46 | NV | Las Vegas | English | Toyota | Mars | Dog | Spinach | 4 | Red
2023-07-19 00:00:00 | 08:16:37 | NV | Las Vegas | English | Ford | Earth | Cat | Tomatoes | 5 | Green
2023-07-20 00:00:00 | 08:19:59 | NV | Las Vegas | Spanish | Honda | Mars | Dog | Cucumbers | 2 | Red
2023-07-21 00:00:00 | 08:29:59 | NV | Las Vegas | French | Toyota | Jupiter | Bird | Bell Peppers | 3 | Green
2023-07-22 00:00:00 | 08:30:26 | TX | Houston | English | Ford | Jupiter | Hamster | Lettuce | 4 | Red
2023-07-23 00:00:00 | 08:30:33 | TX | Houston | English | Honda | Earth | Cat | [NAME] | 1 | Green
2023-07-24 00:00:00 | 08:30:38 | NV | Las Vegas | English | Toyota | Mars | Dog | Carrots | 2 | Green
2023-07-25 00:00:00 | 08:31:22 | TX | Houston | Spanish | Ford | Jupiter | Hamster | Broccoli | 3 | Red
2023-07-26 00:00:00 | 08:34:34 | TX | Houston | French | Honda | Earth | Cat | Spinach | 4 | Green
2023-07-27 00:00:00 | 08:42:14 | NV | Las Vegas | English | Toyota | Mars | Dog | Tomatoes | 5 | Red
2023-07-28 00:00:00 | 08:44:43 | TX | Houston | English | Ford | Earth | Cat | Cucumbers | 1 | Green
2023-07-29 00:00:00 | 08:59:50 | TX | Houston | English | Honda | Mars | Dog | Bell Peppers | 2 | Red
2023-07-30 00:00:00 | 09:06:01 | NV | Las Vegas | French | Toyota | Jupiter | Bird | Lettuce | 3 | Green
2023-07-31 00:00:00 | 09:08:20 | TX | Houston | English | Ford | Jupiter | Hamster | [NAME] | 4 | Red
2023-08-01 00:00:00 | 09:25:46 | TX | Houston | English | Honda | Earth | Cat | Cucumbers | 1 | Green
2023-08-02 00:00:00 | 09:26:43 | NV | Las Vegas | English | Toyota | Mars | Dog | Bell Peppers | 5 | Green
2023-08-03 00:00:00 | 09:30:31 | TX | Houston | French | Ford | Jupiter | Hamster | Lettuce | 4 | Red
2023-08-04 00:00:00 | 09:30:35 | TX | Houston | English | Honda | Earth | Cat | [NAME] | 7 | Green
2023-08-05 00:00:00 | 09:31:04 | NV | Las Vegas | English | Toyota | Mars | Dog | Cucumbers | 6 | Red
2023-08-06 00:00:00 | 09:31:40 | TX | Houston | English | Ford | Earth | Cat | Bell Peppers | 4 | Green
2023-08-07 00:00:00 | 09:32:05 | TX | Houston | French | Honda | Mars | Dog | Lettuce | 5 | Red
2023-08-08 00:00:00 | 09:32:42 | NV | Las Vegas | English | Toyota | Jupiter | Bird | [NAME] | 6 | Green
2023-08-09 00:00:00 | 09:32:46 | TX | Houston | English | Ford | Jupiter | Hamster | Cucumbers | 7 | Red
2023-08-10 00:00:00 | 09:32:48 | TX | Houston | English | Honda | Earth | Cat | Bell Peppers | None | Green
2023-08-11 00:00:00 | 09:33:02 | NV | Las Vegas | Spanish | Toyota | Mars | Dog | Lettuce | 2 | Green
2023-08-12 00:00:00 | 09:33:05 | TX | Houston | Spanish | Ford | Jupiter | Hamster | [NAME] | 3 | Red
2023-08-13 00:00:00 | 09:33:12 | TX | Houston | Spanish | Honda | Earth | Cat | Cucumbers | 4 | Green
2023-08-14 00:00:00 | 09:33:39 | NV | Las Vegas | Spanish | Toyota | Mars | Dog | Carrots | 1 | Red
2023-08-15 00:00:00 | 09:34:09 | TX | Houston | French | Ford | Earth | Cat | Broccoli | 2 | Green
2023-08-16 00:00:00 | 09:34:13 | TX | Houston | English | Honda | Mars | Dog | Spinach | 3 | Red
2023-08-17 00:00:00 | 09:34:22 | NV | Las Vegas | English | Toyota | Jupiter | Bird | Tomatoes | 4 | Green
2023-08-18 00:00:00 | 09:34:42 | TX | Houston | English | Ford | Jupiter | Hamster | Carrots | 5 | Red
2023-08-19 00:00:00 | 09:35:02 | TX | Houston | French | Honda | Earth | Cat | Broccoli | 2 | Green
2023-08-20 00:00:00 | 09:35:15 | NV | Las Vegas | English | Toyota | Mars | Dog | Spinach | 3 | Green
2023-08-21 00:00:00 | 09:35:20 | TX | Houston | English | Ford | Jupiter | Hamster | Tomatoes | 7 | Red
2023-08-22 00:00:00 | 09:35:23 | TX | Houston | English | Honda | Earth | Cat | Carrots | 5 | Green
2023-08-23 00:00:00 | 09:35:34 | NV | Las Vegas | French | Toyota | Mars | Dog | Broccoli | 6 | Red
2023-08-24 00:00:00 | 09:35:40 | TX | Houston | English | Ford | Earth | Cat | Spinach | 3 | Green
2023-08-25 00:00:00 | 09:35:45 | TX | Houston | English | Honda | Mars | Dog | Tomatoes | None | Red
2023-08-26 00:00:00 | 09:36:27 | NV | Las Vegas | English | Toyota | Jupiter | Bird | Carrots | 1 | Green