Spreadsheet: 870682d1717152055-need-help-countifs-index-match-formula-book3
Sheet: Sheet4

Ccode | Inv_No | C1 | C2 | [NAME] | C4 | C5 | C6 | C7 | Grand Total
R-A04-[PHONE] | 812270.937791232 |  |  | 1 |  |  |  |  | 1 |  | Ccode | C1 | C2 | [NAME] | C4 | C5 | C6 | C7
R-A04-[PHONE] | 1383185.642440143 |  |  |  | 1 |  |  |  | 1
R-A04-[PHONE] | 1779664.500391737 |  |  |  | 1 |  |  |  | 1 |  | R-A04-[PHONE]
R-A04-[PHONE] | 583771.1479269592 |  |  |  | 2 |  |  |  | 2 |  | R-A04-[PHONE]
R-A04-[PHONE] | 275038.1742080506 |  |  |  | 1 |  |  |  | 1 |  | R-A04-[PHONE]
R-A04-[PHONE] | 3261977.052061728 | 1 |  |  |  |  |  |  | 1 |  | R-A04-[PHONE]
R-A04-[PHONE] | 1681605.784652395 |  |  |  | 1 |  |  |  | 1 |  | R-A04-[PHONE]
R-A04-[PHONE] | 2872216.668791805 |  |  | 1 |  |  |  |  | 1 |  | R-A04-0023933-05210
R-A04-[PHONE] | 4735257.703871103 | 2 |  |  |  |  |  |  | 2 |  | R-A04-0023933-05211
R-A04-[PHONE] | 2258772.785743835 | 1 |  |  |  |  |  |  | 1 |  | R-A04-0023933-05212
R-A04-[PHONE] | 3735967.973433812 |  |  | 1 |  |  |  |  | 1 |  | R-A04-0023933-05213
R-A04-[PHONE] | 3366930.041032332 |  |  | 1 |  |  |  |  | 1
R-A04-[PHONE] | 1146053.386820836 |  |  |  |  | 1 |  |  | 1
R-A04-[PHONE] | 574878.6074495595 |  |  | 1 |  |  |  |  | 1
R-A04-[PHONE] | 1348786.608269641 |  |  |  | 1 |  |  |  | 1
R-A04-[PHONE] | 3099127.161185806 |  |  | 1 |  |  |  |  | 1
R-A04-[PHONE] | 2205132.598100918 |  |  |  | 1 |  |  |  | 1
R-A04-[PHONE] | 2451411.127491361 |  |  |  | 1 |  |  |  | 1
R-A04-[PHONE] | 4898912.527164011 |  |  |  |  | 1 |  |  | 1
R-A04-[PHONE] | 888152.2584020989 |  |  |  |  | 1 |  |  | 1
R-A04-[PHONE] | 907394.5446697492 |  |  |  | 1 |  |  |  | 1
R-A04-[PHONE] | 1912882.072241422 |  |  |  | 1 |  |  |  | 1
R-A04-[PHONE] | 4244615.378424659 | 1 |  |  |  |  |  |  | 1
R-A04-[PHONE] | 3690210.911296768 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05210 | 770535.6470308257 |  |  |  | 2 |  |  |  | 2
R-A04-0023933-05210 | 631564.9713314679 |  |  | 1 |  |  |  |  | 1
R-A04-0023933-05210 | 1689590.132333818 |  |  |  | 2 |  |  |  | 2
R-A04-0023933-05210 | 4173146.313132084 |  |  |  |  | 2 |  |  | 2
R-A04-0023933-05210 | 729764.1810300313 |  |  | 1 |  |  |  |  | 1
R-A04-0023933-05210 | 4278197.880431406 |  |  |  |  | 1 |  |  | 1
R-A04-0023933-05210 | 286053.9362712 |  | 1 |  |  |  |  |  | 1
R-A04-0023933-05210 | 2821489.989205671 |  |  | 1 |  |  |  |  | 1
R-A04-0023933-05211 | 1690490.256189283 |  |  | 1 |  |  |  |  | 1
R-A04-0023933-05211 | 2306210.891520663 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05211 | 1752904.827788753 |  |  | 1 |  |  |  |  | 1
R-A04-0023933-05211 | 3410123.548553792 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05211 | 464608.8683103621 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05211 | 4531367.865440859 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05211 | 1955926.361239605 | 1 |  |  |  |  |  |  | 1
R-A04-0023933-05211 | 3463850.041741604 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05212 | 4898162.81570756 |  |  | 1 |  |  |  |  | 1
R-A04-0023933-05212 | 2062765.225995011 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05212 | 340243.3792135445 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05212 | 3816014.539413854 |  |  |  |  | 2 |  |  | 2
R-A04-0023933-05213 | 2851934.705537842 |  |  | 1 |  |  |  |  | 1
R-A04-0023933-05213 | 2467131.1049097 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05213 | 4788626.473422984 |  |  | 3 |  |  |  |  | 3
R-A04-0023933-05213 | 1141975.490271937 |  |  |  | 1 |  |  |  | 1
R-A04-0023933-05213 | 960552.1142817643 |  |  |  | 2 |  |  |  | 2
R-A04-0023933-05213 | 2193095.832473979 |  |  |  | 1 |  |  |  | 1