| 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
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. | | |
|
#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. Values remain at 0. F9 does not work. |
|
#5
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. | | |
|
#6
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. |
|
#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
I coppied and pasted this link into
IE7(http://xldynamic.com/source/xld.xlFAQ0024.html and got the "Internet Explorer cannot display the webpage" I do not know if it makes any difference but I am in Berkshire in the UK. Regards Peter "Niek Otten" wrote in message ... 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. | | | | | | | | | | | |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
Hi Peter,
Seems to me you have some other problem; this link works fine for me -- Kind regards, Niek Otten Microsoft MVP - Excel "Peter" wrote in message ... |I coppied and pasted this link into | IE7(http://xldynamic.com/source/xld.xlFAQ0024.html and got the "Internet | Explorer cannot display the webpage" I do not know if it makes any | difference but I am in Berkshire in the UK. | Regards | Peter | | | "Niek Otten" wrote in message | ... | 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. | | | | | | | | | | | | | | | | | | | | | | | |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
Hi, I did a bit of searching and the following works,
http://www.xldynamic.com/source/xld.xlFAQ0024.html but your link does not!! Regards Peter "Niek Otten" wrote in message ... Hi Peter, Seems to me you have some other problem; this link works fine for me -- Kind regards, Niek Otten Microsoft MVP - Excel "Peter" wrote in message ... |I coppied and pasted this link into | IE7(http://xldynamic.com/source/xld.xlFAQ0024.html and got the "Internet | Explorer cannot display the webpage" I do not know if it makes any | difference but I am in Berkshire in the UK. | Regards | Peter | | | "Niek Otten" wrote in message | ... | 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. | | | | | | | | | | | | | | | | | | | | | | | |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
Niek's link works fine for me, however the link you posted works in Firefox
but not in IE6 -- Regards, Peo Sjoblom "Peter" wrote in message ... Hi, I did a bit of searching and the following works, http://www.xldynamic.com/source/xld.xlFAQ0024.html but your link does not!! Regards Peter "Niek Otten" wrote in message ... Hi Peter, Seems to me you have some other problem; this link works fine for me -- Kind regards, Niek Otten Microsoft MVP - Excel "Peter" wrote in message ... |I coppied and pasted this link into | IE7(http://xldynamic.com/source/xld.xlFAQ0024.html and got the "Internet | Explorer cannot display the webpage" I do not know if it makes any | difference but I am in Berkshire in the UK. | Regards | Peter | | | "Niek Otten" wrote in message | ... | 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. | | | | | | | | | | | | | | | | | | | | | | | |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not Calculating
On Fri, 16 Nov 2007 16:13:02 -0800, "Peo Sjoblom" wrote:
Niek's link works fine for me, however the link you posted works in Firefox but not in IE6 This link does not work for me with IE6 http://xldynamic.com/source/xldxlFAQ0024.html I get a "DNS timed out" error. Was fine yesterday Gord |
|
#15
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) | |||
Linear Mode
