Sorting to count

  • Thread starter Thread starter machelleh2
  • Start date Start date
M

machelleh2

Reason Location
BENT 1
POR 2
BENT 2
POR 1
BENT 1

I want to set a formula that will count only the location 1's that ar
bent. Can anyone help?????????????????????:confused:
 
YOu can put in a new column with the following

=if(and(a1="bent",b1=1),1,0)

Then add up the number in this new colum
 
One way,

=SUMPRODUCT((D38:D42="BENT")*(E38:E42=1))

The formula will return the number of records where Location is 1 and Reason is BENT. Adjust the references to suit.

HTH
Anders Silvén
 
Back
Top