| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CountIF Function Help!!
Thank you SO much. That worked great!!!
"Luke M" wrote: Looks like your formula is floating when you fill down. Change it to: =COUNTIF(B$2:B$447,B2) The dollar signs will lock the formula onto those rows, so the array won't move when you copy down. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tina STL" wrote: # Manager Name 8 SIDNEY GRANT 7 SIDNEY GRANT 6 SIDNEY GRANT 5 BALLINGER HOLLOWAY HARMAN 5 SIDNEY GRANT 4 BALLINGER HOLLOWAY HARMAN 4 SIDNEY GRANT Here is the examplet of the return. My Formula is =COUNTIF(B2:B447,B2). What I was hoping for is each time Sidney Grant appears on the spreadsheet it would return 8. Does this make sense? Thank you for any help you can give me, I really appreciate it. "Luke M" wrote: What do you mean it 'counts down'? the formula: =COUNTIF(A:A,"Cat") Would normally give you a count of how many times the word "Cat" appears in column A. What does your formula/data look like that it is not doing what you want? -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tina STL" wrote: I am using the countif to tell me how many times text appears in column. The problem I have is the return seems to be counting down, I need the return to show the total number of times it appears on each line. I hope that makes sense. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AND function using COUNTIF | Excel Worksheet Functions | |||
| please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| CountIf function | Excel Worksheet Functions | |||
Hybrid Mode
