Use of SUMPRODUCT/COUNTIF?

[mfiery]

I have to columns worth of data, the first column is the 'type' the second is the 'outcome' with the outcome either being yes or no.

I need to be able to count the number of times the outcome is 'yes' for each 'type'

I attached a small sample...

[daddylonglegs]

Yes, you can use SUMPRODUCT, i.e. in B15 copied down

=SUMPRODUCT(--(A$2:A$12=A15),--(B$2:B$12="Y"))

[Roger Govier]

I have to columns worth of data, the first column is the 'type' the second is the 'outcome' with the outcome either being yes or no.

I need to be able to count the number of times the outcome is 'yes' for each 'type'

I attached a small sample...

You can also use a Pivot Table to provide the result required.
See example uploaded

[mubashir aziz]

you can even array formula which is sometimes ver help ful to understand and solve the problems .......

AFter entering press Control + Shift + Enter (CSE)

=SUM(IF($A$2:$A$12=A15,1,0)*IF($B$2:$B$12="Y",1,0))