Consider the data table below and choose a right formula for the problem \\#2: COUNTIF to return the number of cells that contain a value other than 0 . 10 1. VLOOKUP a Vender ID to return Balance 11 2. COUNTIF to return the number of cells that contain a value greater than 0 in Balance 12 3. SUMIF to return total balance for the State LA \\[ \\begin{array}{l} =\\text { COUNTIF(G2:G8,"not 0") } \\\\ =\\text { COUNTIF(G2:G8,"<>0") } \\\\ =\\text { COUNTIF(G2:G8,">0 and <0") } \\\\ =\\text { COUNTIF(G2:G8,"!=0") } \\end{array} \\]