counting and filtering

[kevin carter]

hi
i have the following data
A B C
reason time occur
Gripper 10 2
Gripper 10 1
slide 10 5

the range is set to 10 rows 1e(a1:a11)

what i want to do is search column A for duplicate entries adding the
result of time , also if there is no duplicate return the values
ie. Gripper 20
slide 10
i then need to select the top reason in time.

i also want to do is search column A for duplicate entries adding the
result of occur, also if there is no duplicate return the values
ie. Gripper 3
slide 5

i then need to select the top occur in number of occurances
this happens for the first hour.

Can anyone hep me please


thanks in advance

kevin

 

[Stefan Hägglund [MSFT]]

Hi Kevin!

You can use an array formula in column D, like
=SUM(IF(A2:A11="Gripper",B2:B11))
For the next question, use this formula in column E
=SUM(IF(A2:A10="Gripper",C2:C10))

Press CTRL+SHIFT+ENTER (or COMMAND+RETURN on the Mac) to enter the formula
as an array formula.

See http://support.microsoft.com/?id=275165 for more information.


Best regards

Stefan Hägglund
Microsoft

 

[Frank Kabel]

Hi
try
=SUMIF(A:A,"Gripper",B:B)
and
=SUMIF(A:A,"Gripper",C:C)

Or use a pivot table for this