Newspaper Database of Issues Excel, How to Make Statistics for Columns.

[joegeek]

Hello Guys,
I am making an excel Database for my newspaper.
I have huge database of Articles and their Authors and Regions that the article is talking about. I want to make an sheet for statistics. For each Author how many times his name is listed in specific column, also the same idea for the Regions.
I was doing it manually, but Since this database is huge one, i can't do it manual.
See Example

I Need to make this stats Chart or Table to be filled automatically, like if i listed another article for the Author A, automaticaly the Author 'a' Table +1

Thanks

 

[hsk]

One way use Pivot Table ... but simplar way is Formula
You can use formula CountIF ----
Go to Cell J15 : =COUNTIF(I2:I12,"Author a")
Go to Cell J16 : =COUNTIF(I2:I12,"Author b")
Go to Cell J17 : =COUNTIF(I2:I12,"Author c")
Total J18 : =SUM(J15:J17)

Similarly for Region
Go to Cell G15 : =COUNTIF(E2:E12,"Europe")
Go to Cell G16 : =COUNTIF(E2:E12,"Africa")
Total G17 : =SUM(G15:G16)

 

[joegeek]

Thanks Alot, This is a great forum ...
But i have a little Problem, Sometimes in the By-Line Column , there is same two names like (Joseph Smith) and another Cell (Joseph Smith ) but Second one with Extra Space,or comma. When i made the Pivot Table, It didnt Remove Duplicates, So i Found Huge Number of Dublicates,
Also the Formula Didn't Count Some the Authors Because This little extra Spaces or commas i told you about. I tried it and worked with some names effectivly but when i searched using (Ctrl+F > Find all) for Some other Authors that i used the Formula with, It give me Higher Value ...i tried to count them manually , i found that there is 5 Cells with extra Commas and Spaces (By Fault when Data entering)
How Can I solve This problem? is there a fast way to Remove this Commas and Spaces to make the Code work effectivly like the ''Find all'' ?