Do it this way, then:

=COUNTIF(R:R,"RB1")

and if you want to total the contributions which meet that criteria:

=SUMIF(R:R,"RB1",J:J)

Hope this helps.

Pete

On Dec 20, 2:26*pm, JT wrote:
Jacob:

Thanks, however this formula does not find the criterial thatis in the R
column. *Thye J columb contains donations...the R column contains the
criteria that I need the formula to consider as it counts the corresponding J
column cells.



"Jacob Skaria" wrote:
Try the below formula

=COUNTIF(J:J,"RB1")

--
Jacob

"JT" wrote:

The cells in column J contains donations made by various individuals. *Cells
in column R contain certain member classifications. *Am looking for a formula
that looks at column R, then counts the number of entries in the
corresponding cells in colum J for each member classsification. *EX: *in
column R there are three classifications: *RB1, RB2, RB3. *Need to count how
many donations in column J are made by each classification.

Many thanks!- Hide quoted text -

- Show quoted text -