SUMIF for Practice exam question 5
Using sumif to complete the database as required for question 5 was done, but the value returned for each row is times 2 of the value in the solution. What could cause it, and how can it be corrected?
Solutions Formula : =SUMIF(Data!E:E,Output!B4,Data!D:D)
First row value : -14500341
My Formula : =SUMIF(Data!E:E,Output!B4,Data!D:D)
First row value : -14500341
1 answers ( 0 marked as helpful)