Enter a formula in cell E1 using SUMIF to calculate the total quantity in stock for items from the company "ColorFab". Use the range name Company for the Range argument , the text string "ColorFab" for the Criteria argument, and InStock for the Sum_range argument.
A) SUMIF(E:E, "ColorFab", D:D)
B) SUMIF(D:D, "ColorFab", E:E)
C) SUMIF(A:A, "ColorFab", B:B)
D) SUMIF(B:B, "ColorFab", A:A)