count if

  • Thread starter Thread starter cletabujol
  • Start date Start date
C

cletabujol

how do i get the count if function to count based on certain concrete
conditions...if cell a1 >= condition a and <= condition b then add 1
to count...
 
single cell

=IF(AND(A1>=condition_a,A1<=condition_2),1,0)

range of cells

=SUMPRODUCT(--(A1:A10>=condition_1),--(A1:A10<=condition_2))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
You must log in or register to reply here.

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

Count and Sum of cells if conditions fulfilled 12
Conditional count if function 4
COUNTIF Function issue 5
using CountIF function or Array? 3
How to Populate Data from a table to another 0
count cells in a table that meet multiple criteria 1
Counting Colors of Cells set by Conditional Formatting 2
Comparing the values in two cells, then counting how many differ 2

Back
Top