Archive for January, 2010

Ever heard of a B corporation?

Business & entrepreneurship

Last month, I happened to hear about something called a . I’d never heard of it before. , , and C corps, yes, but never a “B” corp. What in the world was this?

It turns out are a relatively new community created by a non-profit group called , a community comprised of businesses who commit to using their business to “solve social and environmental problems”.

To join, businesses have to amend their laws of incorporation to reflect their commitment to be socially responsible as well as . In return, businesses that sign on get certified as “B corporations” and in theory reap the benefits of the certification as its credibility grows. Numi tea, Uncommon Goods, King Arthur Flour are some of the more famous founding companies on B Labs’ website that you may recognize.

Read the rest of this entry »

How to use the COUNTIF and SUMIF functions in Excel — a quick introductory tutorial

Excel function tutorials

I wanted to continue building on my popular series on and by discussing two additional and very useful functions called and . Surprisingly, they’re not as widely used as you’d expect, and sometimes knowing which to use is a bit confusing.

is a function that will count (as in 1, 2, 3…) the number of entries within a range if certain criteria are met, and the data within each entry can be text or numbers.

, on the other hand, is a function that will add the total number of numerical entries within a range if certain criteria are met. This means that sumif only works with numbers when adding up figures, so if your range includes any text, those will be ignored. Let’s walk through a simple example.

Suppose you have the following simple table of sales by type and # for each year from 2003-2009:

Read the rest of this entry »