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
Hello Arowosegbe,
Good to hear from you.
Did you delete the 'Total' row, please?
Best,
Ned
I also deleted the "total"rows and got -17,554,687
Any ideas why I am not getting your answer Ned?
Hey Juan,
Please feel free to send me your workbook: nedko@365datascience.com
I'll take a look.
Best,
Ned
I also had this issue....did anyone find the reason for this?
Hey Kerry, please send me your workbook at the email indicated above and I will be happy to assist.
Best,
Ned