Sumproduct

[kimknguyen]

Help! When I check the Functional Arguments for a formula, I get a value (457), but the result in cell shows 0.0. Can you help with an explanation?

 

[Nebu]

Hi:

In your formula
=IF([@Year]>=2017,(1+VLOOKUP([@Year],'C:\Kim_Master\Daily\Active_ZenSale_2016-08-8.xlsm'!YrOYr[#Data],2,FALSE))*(SUMPRODUCT((AType="Sale")*(ADay=[@Day])*(AMonth=[@Month])*(AYear=[@Year]-1)*AData)/COUNTIFS(ADay,B34,AMonth,E34,AYear,F34)),[@Goal])

The colored part is showing a reference error ,your formula till row 34 worked because the if condition at the beginning of your formula is not satisfied hence the formula is returning the the figure in column K.

Thanks

 

[kimknguyen]

Hi Nebu, thank you for your help. Even when I move the table to the same sheet, it still give me 0 value. Attached is updated file.
Please take a second look. Thanks.

 

[Nebu]

Hi:


Check whether , Enable iterative calculation is checked if not tick the check box.

Thanks

 

[kimknguyen]

Hi:
View attachment 33478

Check whether , Enable iterative calculation is checked if not tick the check box.

Thanks

 

[kimknguyen]

Hi Nebu,
It works!
Thank you so much!
Kim N.