Excel Formula Needed

  • Thread starter Thread starter Barb Manjarres
  • Start date Start date
B

Barb Manjarres

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?
 
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.
 
Back
Top