| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using CountIf with non-adjacent cells in same column
I am trying to find a count of the letter "A" in the first column. I want to
skip over ten cells (A80 - A90) and continue on counting from A91 and on. I do not want A80 - A90 to be in the count. Is this possible to do? What would the formula be? Any advice would be much appreciated!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using CountIf with non-adjacent cells in same column
perhaps
=Counfif(A1:A79,"A")+countif(A91:A1000,"A") "RS" wrote: I am trying to find a count of the letter "A" in the first column. I want to skip over ten cells (A80 - A90) and continue on counting from A91 and on. I do not want A80 - A90 to be in the count. Is this possible to do? What would the formula be? Any advice would be much appreciated!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using CountIf with non-adjacent cells in same column
Perfect! Thank you!!
"Toppers" wrote: perhaps =Countif(A1:A79,"A")+countif(A91:A1000,"A") "RS" wrote: I am trying to find a count of the letter "A" in the first column. I want to skip over ten cells (A80 - A90) and continue on counting from A91 and on. I do not want A80 - A90 to be in the count. Is this possible to do? What would the formula be? Any advice would be much appreciated!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using CountIf with non-adjacent cells in same column
Just so you know of the different ways to do this, you could also use:
=Countif(A1:A1000,"A")-countif(A80:A90,"A") Regards, Paul "RS" wrote in message ... Perfect! Thank you!! "Toppers" wrote: perhaps =Countif(A1:A79,"A")+countif(A91:A1000,"A") "RS" wrote: I am trying to find a count of the letter "A" in the first column. I want to skip over ten cells (A80 - A90) and continue on counting from A91 and on. I do not want A80 - A90 to be in the count. Is this possible to do? What would the formula be? Any advice would be much appreciated!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| Countif across multiple non-adjacent cells | Excel Discussion (Misc queries) | |||
| summing values from adjacent column with refrence from adjacent column | Excel Discussion (Misc queries) | |||
| Sum column if multiple criteria are met in adjacent cells | Excel Worksheet Functions | |||
| How do I use countif across non-adjacent cells? | Excel Worksheet Functions | |||
Linear Mode
