Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count formula problem
I have a formula in excell to count the amount of cells that contain numbers.
I use this formula =COUNT(A1:A90) and if the count was 30 I would get 31. I have two other sheets in the same file where the calculations are correct. The only way I can get the correct calculation is to do this formula =COUNT(A1:A90)-1 Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count formula problem
Is there a cell that you think is text, but in fact is a number?
Can you restrict your range of cells to a smaller range, hence see whether the formula is correct or not? Do this continuously until you get the cell that is causing the divergence. Perhaps merged cells could be a problem. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Len" wrote: I have a formula in excell to count the amount of cells that contain numbers. I use this formula =COUNT(A1:A90) and if the count was 30 I would get 31. I have two other sheets in the same file where the calculations are correct. The only way I can get the correct calculation is to do this formula =COUNT(A1:A90)-1 Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
count formula problem
See if this helps you spot the "extra" number. Select the cells from A1 to
A90 by typing A1:A90 in the Name Box (the blank box to the left of the Formula Bar), click Format/ConditionalFormatting from Excel's menu bar, select "Formula Is" from the first drop-down box, copy/paste this... =COUNT(A1)=1 into the blank field next to it, click the Format button and select a color from the Patterns tab, then OK your way back to the worksheet. All the numbers being counted by the formula you posted will be highlighted in the color you selected. Just look at each of them to see what is being counted that you did not think should be counted. When you are done, you can go back to the Conditional Formatting dialog box and Delete the conditional format. Rick "Len" wrote in message ... I have a formula in excell to count the amount of cells that contain numbers. I use this formula =COUNT(A1:A90) and if the count was 30 I would get 31. I have two other sheets in the same file where the calculations are correct. The only way I can get the correct calculation is to do this formula =COUNT(A1:A90)-1 Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Programming | |||
Count formula problem | Excel Worksheet Functions | |||
Count Formula Problem | Excel Worksheet Functions | |||
Problem with Count IF Formula | Excel Worksheet Functions |