countif or sumproduct help

[gatgame]

Hello I would like to display in the respected columns DEF (table) the total number of times assist, escelation, & other were used per name. I.e. see table. Also I will have 50-100 different Names, repeating various times with different Types. Thank you.

A B C D E F
Name Type Name Assist Escelation Other
Sara assist Sara result formula result formula result formula
Tim escelation Tim 2 1 0
Joe assist Joe
Tom assist Tom
Sara escelation Jane
Tim assist
Sara assist
Jane other
Tim assist

[JBeaucaire]

In cell D2, place the following formula and copy down and over:

=SUMPRODUCT(($A$2:$A$10=$C2)*($B$2:$B$10=D$1))

[deadlyduck]

Depending on the layout of your data file, this might be achievable using a Pivot table.
Alternatively maybe the COUNTIF() function might be usable. Equally, the SUMPRODUCT() function could be a possibility.

If you could upload a copy of your file you'd probably get a more precise answer.

[gatgame]

Yah sorry didnt see attachment here is a sample sheet:

Book1.xls

[shg]

E3 and copy across and down, =SUMPRODUCT( ($A$2:$A$20 = $D3) * ($B$2:$B$20 = E$2) )

[rwgrietveld]

There is more than one way, but for the table you've created simply use this:

=SUMPRODUCT(--($A$3:$A$16=$D3),--($B$3:$B$16=E$2))