Thread: Not Calculating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Dobony Mike Dobony is offline
external usenet poster
  
Posts: 7
Default Not Calculating
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.


Reply With QuoteReply With Quote