Counting Cells

  • Thread starter Thread starter markinblackuk
  • Start date Start date
M

markinblackuk

I wish to count the cells in one column using criteria in another
column. The criteria is in Text form. Any help Please!!! :cool:
 
You don't give enough details to truly understand your need. However
this may steer you in the right direction:

=COUNTIF($A$1:A21,"="&B1)

will count the number of times the value in cell B1 appears in th
range A1:A21

HT
 
Hi there,

I think you need to use countif.

so, if your list of things you want to count is in A2:A10 and th
criteria by which you want to count is in cell b2, the formula in cel
c3 will be:

=COUNTIF(A2:A10,B2)

(=countif(range,criteria)

hope this helps!

thanks,

MoonWeaze
 
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

Excel Count Formula in Excel 0
Access Dcount (multiple criteria) 3
Index with partial text 1
Excel Need Countifs Formula Help 0
Countif, index and match 2
Count cells if next column has text 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
COUNTIFS with No Criteria 1

Back
Top