Spreadsheet: 713040d1610538152-nested-if-statements-using-index-and-match-cannot-get-them-to-sum-index-match-which-sums-also
Sheet: pins

 |  | 362539838759424523 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838759318790 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838759260629 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838759219978 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838759208041 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838759164922 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838759155504 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORGANIC
 |  | 362539838759145769 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838759069781 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838758972647 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838758756439 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838758571478 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838758519699 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BOTH
 |  | 362539838758519690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD |  |  |  |  | THIS IS RETURNING FIRST VALUE OF VALUE IN C2, NOT SUMMING ALL VALUES MATCHED IN C2
 |  | 362539838758509717 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD |  |  |  |  | VALUE SHOULD BE
 |  | 362539838758363419 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORGANIC
 |  | 362539838758282724 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838758268926 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838758268896 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838758268883 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838758268707 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838758170972 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838758044696 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838758010669 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838757698399 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838757417385 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838757274973 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838756999209 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838756999143 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838756772029 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838756677491 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838756677486 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838756677407 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838756677388 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838756677334 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838756677294 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838756677266 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838756677214 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OMD
 |  | 362539838756539065 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838756522982 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW
 |  | 362539838756439642 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KROW