| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
"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. When you say "not calculating", what is happening? Check in Tools Options Calculation tab that calculation is set to automatic. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
"Stephen" <none wrote in message ... "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. When you say "not calculating", what is happening? Check in Tools Options Calculation tab that calculation is set to automatic. Values remain at 0. F9 does not work. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
"Stephen" <none wrote in message ... "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. When you say "not calculating", what is happening? Check in Tools Options Calculation tab that calculation is set to automatic. I get only a value of 0. F9 does not work either. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
Hi Mike,
Check this list: http://xldynamic.com/source/xld.xlFAQ0024.html -- 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. | | |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
"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. | | |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. | | |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
It's not working for me either?
Regards Peter "Peo Sjoblom" wrote in message ... 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. | | |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
Make sure your default browser is Internet Explorer, or paste the link into your browser instead of just clicking it
-- Kind regards, Niek Otten Microsoft MVP - Excel "Peter" wrote in message ... | It's not working for me either? | Regards | Peter | "Peo Sjoblom" wrote in message | ... | 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. | | | | | | | | | | | |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
"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. | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Help | Excel Discussion (Misc queries) | |||
| calculating | Excel Discussion (Misc queries) | |||
| Calculating Age | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| calculating an age | Excel Discussion (Misc queries) | |||
Hybrid Mode
