If I visit any of the blog online, I used to see their archive to know the total number of posts. I do, bit analysis about the age of the blog, frequency of number of posts, number of feedburner subscribers etc.,

If number of posts are less, we can easily count the total. If number of posts are more and they enabled archive for weekly subtotal, it is very difficult to calculate the total number of posts for aged blogs.

Today, I will explain you how to count total number of posts from archive for any of the blog by using our MS Excel.

__What is 'archive' in blog?__
Blog 'archives' are history of your blog. These archives are acting as additional webpages, that contain all of your older posts. In simple terms, blog archives stores all of your posts so that they will always be there for others to read.

If you observe the first blog archive has the weekly frequency and the second has monthly frequency.

__Steps to count total number of posts from archive in blog__1. Go to any of the blog (which should enable the archive feature on the home page)

Ex: www.lostinexcel.blogspot.com

2.

*Right click*on the homepage

3. Click

*View page source*(then webpage code window opens)

4. Find for

*"archive"*by using

*Ctrl+F*shortcut

5. If you find more than one "archive" you have to choose the correct "archive" word (where the list of months / weeks)

6. Copy the code just above from the first month/week code till last month / week code (see reference screenshot below)

7. Open an Excel and Paste the code over there. (either by using Paste special

__V__alues / Paste special

__T__ext) - Let say, you have pasted in column A from Cell A1

8. Enter the below formula in Cell B1

=

**MID**(A1,SEARCH("(",A1)+1,SEARCH(")",A1)-SEARCH("(",A1)-1)

9. Drag the formula from Cell B1 to the last Cell till data ends

10.

*Copy*Column B - Paste as

*Paste special*in Column C - Convert all the items as numbers

__v__alues11. Total it by using

*Sum*function.

12. Thats All !!

There is not a soul who does not have to beg alms of another, either a smile, a handshake, or a fond eye. See the link below for more info.

ReplyDelete#beg

www.inspgift.com

I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often..

ReplyDeleteChix

www.imarksweb.org

please keep us informed like this; it carries awesome and actually good data in favor of readers.

ReplyDeletewww.n8fan.net

I really enjoyed reading your article. I found this as an informative and interesting post, so i think it is very useful and knowledgeable. I would like to thank you for the effort you have made in writing this article.

ReplyDeleteedupdf.org

Good day! I found your site very interesting and informative . Thanks for taking time sharing it with us. I really enjoyed reading your post.

ReplyDeletetriciajoy.com

www.triciajoy.com

I read your blog.I thought it was great.. Hope you have a great day. God bless.

ReplyDeleteRica

www.imarksweb.org