Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

07 Feb 2024

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

 

5 answers ( 0 marked as helpful)
Instructor
Posted on:

25 Apr 2023

1

Hello Arowosegbe,

Good to hear from you.

Did you delete the 'Total' row, please?

Best,

Ned

Posted on:

01 Feb 2024

0

I also deleted the "total"rows and got -17,554,687


Any ideas why I am not getting your answer Ned?

Instructor
Posted on:

01 Feb 2024

0

Hey Juan,

Please feel free to send me your workbook: nedko@365datascience.com

I'll take a look.

Best,

Ned

Posted on:

07 Feb 2024

0

I also had this issue....did anyone find the reason for this?

Instructor
Posted on:

07 Feb 2024

0

Hey Kerry, please send me your workbook at the email indicated above and I will be happy to assist. 

Best,

Ned

Submit an answer