Hello and thank you in advance for any help! Having an issue with "Formulas"

**KALW1** · 08-31-2012, 03:35 PM

I am a user of Excel at a pretty pedestrian level - I am guessing I will be asking questions more than anything else.

I am wanting to apply the formulas "SUM" and "COUNT" to a range of (a few hundred) lines of financial data. The data within the range are updated daily. In the past when I have set up this kind of worksheet, with the same two formulas, the outputs (Sum and Count) were updated by Excel in dynamic fashion, as content on each line was updated. Now, in order to get the updated output, I have to place the cursor IN the formula cell, in/on the text of the formula and then hit enter. Then the output is updated to the correct Count or Sum.

I am not sure what I might have inadvertently done differently to set up this kind of restriction on the worksheet.

Thank you for any help.

**Paul** · 08-31-2012, 05:14 PM

Hi Kalw1, welcome to the forum!

This sub-forum is just for introductions, so please post your question(s) in a new thread in a relevant sub-forum such as Formulas/Functions (with an appropriate thread title, of course).

There's a link to the forum rules in my signature below, which I'd recommend reading prior to posting just so you don't get off on the wrong foot.

Thanks!