Microsoft Excel Formula that will not calculate - TechRepublic
Question
November 27, 2009 at 09:52 AM
clint5823

Microsoft Excel Formula that will not calculate

by clint5823 . Updated 16 years, 7 months ago

Hello, I’m building an excel spreadsheet to study how coupons are being redeemed and how they affect revenue . The excel formula I’ve been 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))}. Now I realize “F125” may conflict with a cell reference in excel, however, I have other codes that are similar to this one and they are calculating. My question is, how come this formula in particular is not calculating, while others will?

This discussion is locked

All Comments