Last answered:

25 Apr 2023

Posted on:

25 Apr 2023

0

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)
Posted on:

25 Apr 2023

0

Hello Arowosegbe,

Good to hear from you.

Did you delete the 'Total' row, please?

Best,

Ned

Submit an answer