• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If ...and .... then ... count .... or is it sum?

M

MissG

New Member
I'm sure this has been asked before, but I'm going round in circles here! I'm a bit new to ye olde excel (!), so advice of the wiser and more experienced, would be very grateful.


So, I have a small marketing data gathering spreadsheet. I want to know where the leads come from and from the leads, how many actually turned into real jobs.


I've used countif to count how many out of my enquiries came from which source.


I've also used countif to count how many of my total enquiries turned into business (false) and which were just quotes that didn't materialise.


What I want to do is this .... Say I have a total of 1500 enquiries and I find out 150 of these come from Google, but only 15 of them turn into business, what is the formula for this? I can see what the answer should be (I think), by using filters on the main data sheet, but I want to set formulas, so that I can create a summary sheet for ease of reference and automatic updating everytime the data is added to.


This must be simple. Someone out there must do it all the time ....


Advice gratefully received.


Miss G
 
Sumproduct would work great for this!. Please post a sample Workbook.


Look at the green sticky posts for more information on how to upload a workbook
 
Hi, MissG!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


Why not try using LARGE and SMALL functions? They operate on a matrix and retrieve the nth. value in order? If that isn't what you're looking for, please consider uploading a sample file and elaborate a bit more.


Regards!
 
MissG


Firstly, Welcome to the Chandoo.org forums.


You may also want to look at this post: http://chandoo.org/wp/2011/11/18/formula-forensics-003/
 
Hey everyone - thanks for the comments. I have said a 'Hello' in the introduction place and had a read through some of the sticky notes. I did have a search before posting but didn't find *quite* what I was looking for. I'll try sumproduct, but will probably upload a small spreadsheet extract as well, partly for reassurance, but also because with so many people here who know excel so well, someone is bound to know a slicker, tidier way of doing this .......
 
Posting a sample file is the best way to get a specific result:

Refer: http://chandoo.org/forums/topic/posting-a-sample-workbook
 
You must log in or register to reply here.
Back
Top