Thread: Not Calculating
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Not Calculating

No it it's not.


--


Regards,


Peo Sjoblom


"Mike Dobony" wrote in message
...

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

Check this list:

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


That site is down.

--
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.
|
|