The tab count button in the toolbar will keep track of the number of tabs with webpages you have open at the moment. Clicking will show an overview of all windows with the number of tabs.
Only web page tabs are tracked, so not mail or IRC tabs.
Tracking starts once a page is (re)loaded. Restarting Opera after installing will make sure all possible tabs are tracked.