SUMIF for Practice exam question 5

Question

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

Answer 1

Hello Arowosegbe,

Good to hear from you.

Did you delete the 'Total' row, please?

Best,

Ned

Answer 2

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

Any ideas why I am not getting your answer Ned?

Answer 3

Hey Juan,

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

I'll take a look.

Best,

Ned

Answer 4

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

Answer 5

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

Best,

Ned

SUMIF for Practice exam question 5

Submit an answer

related questions