You need to calculate the total number of items ordered by customers from Texas. Two-letter state abbreviations are in Column B and quantity ordered is in Column G. There are 200 rows in the spreadsheet, with a header row. What is the exact function you would use? =SUMIF(G1:G200, "=TX", B1:B200) O=COUNTIF(G2:G200, "TX", B2:8200) O =SUMIF(B2:B200, "=TX, G2:G200) O =SUMIFS(B2:B200,"TX", G2:G200, >0) O=COUNTA(B2:B200, "=TX)