Counting all rows that have a specific answer from drop down box

[Puk87]

I have created an Excel 2013 spreadsheet to keep track of income from various sources of advertising etc. Each invoice is recorded with its various different details. At the end of each row there is a drop down box to select the form of advertising which the job arose from.

I am trying to create a formula to count the total income and total entries from each different source but I am really struggling. I was wondering if someone could help me please.

I have included an image to show my spreadsheet. I would like the bottom table to automatically draw the information from the top one.

Thanks very much for any help or advice offered.

Excel_zpsnxituulc.png

EDIT - I have attached a sample database, hopefully my question makes sense. Apologies for the lack of knowledge on my part.

[mehmetcik]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

[Tony Valko]

Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.

[Puk87]

Thank you very much to you both, i will upload a sample now.

[FDibbins]

Also know that the contents of a DD are exactly the same as if you had typed them in. No special formula or treatment is needed when working with them

[Puk87]

I have now added in a sample database.

Apologies I do not know what a DD is. Im not very computer literate im afraid

Edit, Oh i understand, a DD meaning drop down. I opted for a drop down as I figured the formula would relate to the DD option, therefore if for some reason there was a typo in that box it would be missed off the bottom table.

[FDibbins]

yes, DD = Drop Down

A DD is essentially used to restrict entry to a specified list and to help avoid typos and save on typing

[mehmetcik]

Formula for F49:

Please Login or Register  to view this content.

Formula for G49:

Please Login or Register  to view this content.

Formula for K49:

Please Login or Register  to view this content.

Formula for L49:

Please Login or Register  to view this content.

[Puk87]

Thank you so much, thats worked a treat :D

[Puk87]

Sorry mehmetcik, that last formula (L49) doesnt seem to work

[mehmetcik]

Try this:-

Please Login or Register  to view this content.

[Puk87]

Perfect thank you so much!