"Niek Otten" wrote in message
...
Hi Mike,

Check this list:

http://xldynamic.com/source/xld.xlFAQ0024.html


I followed the directions and it still will not recalculate the formula.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mike Dobony" wrote in message
...
|I have a formula in 2 worksheets that work fine. I copied one of the
| worksheets and changed the data. The new worksheet is not calculating
the
| formula "=AVERAGE(IF((F4:F31=(H2))*(F4:F31<=(J2)),Q4:Q31) )". Any ideas
on
| why this is not calculating? I have Excel 2002 SP3.
|
| Mike D.
|
|