Microsoft Excel Formula that will not calculate

By Clint5823 ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

What are you trying to SUM?

by ThumbsUp2 In reply to Microsoft Excel Formula t ...

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.

Related Discussions

Related Forums