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
Last edited by skate1991; 02-13-2012 at 05:52 AM.
A pivot table would be the most straightforward.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
try with Pivot table
"Relax. What is mind? No matter. What is matter? Never mind!"
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.
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
I don't think changing manualy few thousand names is a good approach :/
"Relax. What is mind? No matter. What is matter? Never mind!"
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
Sorry didnt mean to re post, Was trying to change the title of the post,
And is there a way using a countif or sumif function, I think thats what I use to use to get the information
Thanks
@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..
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
Maybe this with COUNTIFS function:
In first row you have filter so you can filter out each name.
"Relax. What is mind? No matter. What is matter? Never mind!"
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
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
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:
"Relax. What is mind? No matter. What is matter? Never mind!"
I'm using excel 2010, Any idea what the countifs formula would be thanks
See Zbor's example.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks