Excel 2007 Gurus

[Tsaico]

I have two columns. The first one is a sale's person's name and the second is their ability to flip a customer, yes (no is a blank cell). I want to count how many times the same sales person joe was able to flip a customer (the "y"). So the condition would be many cell rows, but only count the instance where both column 1 and column 2 were Joe AND "y".

I know it should be a simple thing, but for some reason, i just can't get the syntax down.

example:

Joe |"y"
Joe |
Joe |
Sally |
Joe |"Y"
Sally |"y"
_______
Total Joe =2 ; sally = 1


Where did I go wrong?

---

Moved to SfW.

Zim Hosein

Off Topic Moderator.

 

[KLin]

Originally posted by: Tsaico
I have two columns. The first one is a sale's person's name and the second is their ability to flip a customer, yes (no is a blank cell). I want to count how many times the same sales person joe was able to flip a customer (the "y"). So the condition would be many cell rows, but only count the instance where both column 1 and column 2 were Joe AND "y".

I know it should be a simple thing, but for some reason, i just can't get the syntax down.

example:

Joe |"y"
Joe |
Joe |
Sally |
Joe |"Y"
Sally |"y"
_______
Total Joe =2 ; sally = 1


Where did I go wrong?

You posted in the wrong forum. That's where you went wrong.

http://forums.anandtech.com/ca...tid=33&flcache=6850508

 

[KeithTalent]

Originally posted by: KLin
You posted in the wrong forum. That's where you went wrong.

http://forums.anandtech.com/ca...tid=33&flcache=6850508

This.

KT

 

[tontod]

Originally posted by: Tsaico
I have two columns. The first one is a sale's person's name and the second is their ability to flip a customer, yes (no is a blank cell). I want to count how many times the same sales person joe was able to flip a customer (the "y"). So the condition would be many cell rows, but only count the instance where both column 1 and column 2 were Joe AND "y".

I know it should be a simple thing, but for some reason, i just can't get the syntax down.

example:

Joe |"y"
Joe |
Joe |
Sally |
Joe |"Y"
Sally |"y"
_______
Total Joe =2 ; sally = 1


Where did I go wrong?

I had to do something similar at work, use the COUNTIF function. Should be like this:

COUNTIF(AX:AY,"y")

Where AX and AY would be your cell range.

 

[AreaCode707]

Originally posted by: Tsaico
I have two columns. The first one is a sale's person's name and the second is their ability to flip a customer, yes (no is a blank cell). I want to count how many times the same sales person joe was able to flip a customer (the "y"). So the condition would be many cell rows, but only count the instance where both column 1 and column 2 were Joe AND "y".

I know it should be a simple thing, but for some reason, i just can't get the syntax down.

example:

Joe |"y"
Joe |
Joe |
Sally |
Joe |"Y"
Sally |"y"
_______
Total Joe =2 ; sally = 1


Where did I go wrong?

Pivot Table with sales person name in the first row, the customer in the second row and sales person name or some other element as data.

 

[arcenite]

macro? pseudocode...

create a 2-d array of size (#unique names, 1)

x = 0
for each unique name
namesAndCounts(x, 0) = name
namesAndCounts(x, 1) = 0

x = x + 1
next

x2 = x
x = 0

for each name in column(a)
while x < x2
if namesAndColumns(x, 0) = column(a) and column(b) = "y" then
namesAndColumns(x, 1) = namesAndColumns(x, 1) + 1
x = x2
else
x = x + 1
end if
wend
x = 0
next


...or something like that

 

[rayray2]

just get rid of all the rows containing deadbeats who can't flip a customer leaving only the y's, then just sort by name and do a subtotal (in the data tab) by name.

 

[NeoV]

countif function would do the trick

pivot table would also work - use 'count' instead of sum

 

[Billb2]

Originally posted by: Tsaico
I have two columns. The first one is a sale's person's name and the second is their ability to flip a customer, yes (no is a blank cell). I want to count how many times the same sales person joe was able to flip a customer (the "y").

You should be using Access, not Excel.