Using CountIf with non-adjacent cells in same column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to countif when using indirect cell 1
Countif, Sumif?? 1
Excel Need Countifs Formula Help 0
count formula problem 2
Excel Use COUNTIF across a range of cells with formulas 0
Excel Countif cell has diagonal border 6
Selecting specific cells in a column using countif 1
Sum a column correctly after more info is added by sorting 9

Back
Top