Making SUMIFS, COUNTIFS, & AVERAGEIFS functions in Google Spreadsheet

Update Dec 2013: In the new version of Google Spreadsheets SUMIFS, COUNTIFS, and AVERAGEIFS are already built in. If you didn’t activate the new version yet: read on below!

If you’re used to working in Excel, you’re probably using the SUMIFS, COUNTIFS and AVERAGEIFS functions all the time. When switching to Google Spreadsheet I ran into the problem that I couldn’t use those functions as Google didn’t include them. They only offer the single criterion SUMIF and COUNTIF  and don’t support multiple criterion functions. Luckily, they do offer the FILTER function, which we can use to solve this problem. In this post I’ll show you how you can increase your Google Spreadsheet productivity by replicating the behavior of aforementioned … continue reading »

Using ImportHTML to scrape Facebook Usage numbers

Today I’m going to show how to make an nice map visualization of the Facebook Penetration numbers per country using Google Spreadsheets.

For this I am going to explain how to use the ImportHTML function of Google Docs and show you a quick, but very useful, way to create beautiful maps.

Don’t worry, we only need to perform 4 simple steps to get a nicely looking, informative result like shown … continue reading »