Try something like this:

=SUMPRODUCT(--(A1:A10="Barb"),--(B1:B10="R"))

Better to use cells to hold the criteria:

D1 = Barb
E1 = R

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))

Note that with SUMPRODUCT you *can't* use entire columns as range references
unless you're using Excel 2007.

--
Biff
Microsoft Excel MVP


"Barb Manjarres" wrote in message
...
I would like to know how to make excel check an entire column line by line
for a particular name and if the name exists I want it to go to another
row
and count up all the "R" that are there for that name. Does anyone know
how
to do this?
--
Barb