Software

Ask something
Question Locked

Microsoft Excel Formula that will not calculate

0 helpful
2 replies

by clint5823

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by thumbsup2

First of all, if you're typing the { } bracket characters, your entry is being treated as text and not a formula. Those are reserved characters used by the Conditional Sum Wizard. You can't type them.

You also can't use conditional sums unless you go through the Conditional Sum Wizard. If you leave the brackets off and type in JUST the formula, it sums the entire column C4:C15000.

This discussion is closed to new replies.