| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counta problem - Wrong total
=COUNTA(D1:D22,"=A27")
In the above formula I believe I am counting the number of instances the name in A27 appears in the list from D1 to D22. In the actual list the name in A27 actually only appears once, but the formula is telling me it appears 23 times. I think I am not doing something right. Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula total wrong | Excel Worksheet Functions | |||
| CountA problem | Excel Discussion (Misc queries) | |||
| Sum Function with wrong total shown | Excel Worksheet Functions | |||
| My autosum total is incorrect - what is wrong? | Excel Discussion (Misc queries) | |||
| total and subtotal positions wrong in excel | Excel Discussion (Misc queries) | |||
Threaded Mode
