How to count total number of posts from archive in any Blog?

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.

The following are the screenshots of archives in different blogs.













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 Values / Paste special Text) - 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 values in Column C - Convert all the items as numbers

11. Total it by using Sum function.

12. Thats All !!