Hello,
I'm building a spreadsheet to analyze how coupons are being redeemed within a range of postal codes and how revenue is affected between new and repeat customers. One of the formulas I'm using is:
{=SUM(IF('ENTER INFO HERE'!$F$4:$F$15000="T9E",IF('ENTER INFO HERE'!$G$4:$G$15000="F125",'ENTER INFO HERE'!$C$4:$C$15000,0),0))}
Column A= Store #
Column C= New Customers
Column D = Repeat Customers
Column E= Revenue Generated
Column F= Postal Code
Column G= Coupon Code
Column I= True or false value dependant on the value of Column C where if column C=0 it shows a value of "N" and "Y" when column C=1.
According to the information entered into worksheet 'ENTER INFO HERE', I should be getting a value of 5, but I'm getting 0. I'm having the same problem with the other formulas in this area as well. For some reason, the combination of "T9E" and "F125" will not calculate for Column C,D or Column E in this area of the spreadsheet. There is no 'ERROR' OR '#VALUE' message so I'm not sure what is causing the problem. What stumps me is that I'm using similar formulas throughout this worksheet, and they are calculating properly. For instance, I'm also using the following formula: {=SUM(IF('ENTER INFO HERE'!I$4:I$15000="Y",IF('ENTER INFO HERE'!A$4:A$15000=5,IF('ENTER INFO HERE'!G$4:G$15000="F125",'ENTER INFO HERE'!C$4:C$15000,0),0)))}, and this formula is calculating correctly. I'm hoping someone out there will be able to give me a reason why this formula will not calculate any results. HELP!!!!
Bookmarks