| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making COUNTIF update in real time
How do I make countif update in real time? For example, in column A1 I have
this formula: =COUNTIF(A2:A5,"F") in cells A2:A5 I have F P f X My formula returns 2 IF the data is already present. But if I change the data to: F f F P my formula still returns 2 UNLESS I click on the cell the formula is in and hit enter again. Then it will recalculate. But how do I make the formula return the answer in real time like the SUM function does? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making COUNTIF update in real time
It works OK for me, do you have Calculation set to manual? (Tools Options
Calculation, check 'Automatic') Regards, Alan. "Bishop" wrote in message ... How do I make countif update in real time? For example, in column A1 I have this formula: =COUNTIF(A2:A5,"F") in cells A2:A5 I have F P f X My formula returns 2 IF the data is already present. But if I change the data to: F f F P my formula still returns 2 UNLESS I click on the cell the formula is in and hit enter again. Then it will recalculate. But how do I make the formula return the answer in real time like the SUM function does? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making COUNTIF update in real time
That was the problem. Somehow my calculation got set to manual. Works fine
now. Thanks! "Alan" wrote: It works OK for me, do you have Calculation set to manual? (Tools Options Calculation, check 'Automatic') Regards, Alan. "Bishop" wrote in message ... How do I make countif update in real time? For example, in column A1 I have this formula: =COUNTIF(A2:A5,"F") in cells A2:A5 I have F P f X My formula returns 2 IF the data is already present. But if I change the data to: F f F P my formula still returns 2 UNLESS I click on the cell the formula is in and hit enter again. Then it will recalculate. But how do I make the formula return the answer in real time like the SUM function does? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making COUNTIF update in real time
Check the format of A1 containing the formula... is it formatted as TEXT?
Change it to General... "Bishop" wrote: How do I make countif update in real time? For example, in column A1 I have this formula: =COUNTIF(A2:A5,"F") in cells A2:A5 I have F P f X My formula returns 2 IF the data is already present. But if I change the data to: F f F P my formula still returns 2 UNLESS I click on the cell the formula is in and hit enter again. Then it will recalculate. But how do I make the formula return the answer in real time like the SUM function does? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making COUNTIF update in real time
On Mar 16, 10:26 pm, Bishop wrote:
How do I make countif update in real time? For example, in column A1 I have this formula: =COUNTIF(A2:A5,"F") in cells A2:A5 I have F P f X My formula returns 2 IF the data is already present. But if I change the data to: F f F P my formula still returns 2 UNLESS I click on the cell the formula is in and hit enter again. Then it will recalculate. But how do I make the formula return the answer in real time like the SUM function does? Hi, sometimes it is necessary to force Excel to "rebuild" the formula after a change event; have a look at http://www.excelforum.com/excel-prog...ithout-f2.html Cheers Michael |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use date formula to update workbook in real time | Excel Worksheet Functions | |||
| how do you store real time in excel when making an entry | Excel Worksheet Functions | |||
| Real-time update of chart using a Spin Button | Charts and Charting in Excel | |||
| Excel 2003's autosum does not update data in real time | Excel Worksheet Functions | |||
| How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
Hybrid Mode
