Excel Formula Needed
 

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

Excel Formula Needed
 

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

Excel Formula Needed
 

Hi Barb,

SUMIF is probably the function you are looking,
or maybe SUMPRODUCT.

Take a look at this site for info on the use of both functions.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

HTH
Martin



"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