Problem Counting Text in excel

[skate1991]

HI

Must be one of those mornings I do this task on a regular basis but for some reason the weekend must of been too long and I can’t seem to do it, Started to stress me out, so I thought I would see if anyone could help refresh my brain.

I have two columns, One with the name of the person and one with whether they made the sale yes or no, I want to add up all the knows no's and yes's against each person.

Please see the attached example

Thanks

[Domski]

A pivot table would be the most straightforward.

Dom

[zbor]

try with Pivot table

[Fotis1991]

Hi

Try with SUMPRODUCT.

=SUMPRODUCT(($A$1:$A$29="Joe")*($B$1:$B$29="No"))

=SUMPRODUCT(($A$1:$A$29="Joe")*($B$1:$B$29="Yes"))

Same for the others.

Hope to helps you.

[zbor]

I don't think changing manualy few thousand names is a good approach :/

[skate1991]

HI

Must be one of those mornings I do this task on a regular basis but for some reason the weekend must of been too long and I can’t seem to do it, Started to stress me out, so I thought I would see if anyone could help refresh my brain.

I have two columns, One with the name of the person and one with whether they made the sale yes or no, I want to add up all the knows no's and yes's against each person.

Please see the attached example

Thanks

[skate1991]

Sorry didnt mean to re post, Was trying to change the title of the post,

[skate1991]

And is there a way using a countif or sumif function, I think thats what I use to use to get the information

Thanks

[Fotis1991]

@zbor

No this is not good idea. But if you have a list with the names(and in this case must be a list), then it's easily to do this..

[zbor]

Maybe this with COUNTIFS function:

In first row you have filter so you can filter out each name.

[Domski]

Are you using Excel 2010 or 2003? If the latter then you could use COUNTIFS rather than SUMPRODUCT. Personally though I think the Pivot Table is by far the best approach for something like this.

Dom

[zbor]

I agree with Domski. PT is best way to go.

But if you don't want to use it here is 3rd approach, with new list:

[skate1991]

I'm using excel 2010, Any idea what the countifs formula would be thanks

[Domski]

See Zbor's example.

Dom