July 02, 2006

Another Day Another Function

After I said that I mostly ignored spreadsheet functions, I just found another one that I can use. I'm currently tallying zipcodes on a list, so I found out how nifty the "countif" function is.

Countif.jpg

No thanks to Irving Berlin, here's the formula: =COUNTIF(A1:A6;"Blessing")

Posted by mastr at July 2, 2006 12:54 PM
Comments

Cindy,

Good point, especially if you are Irving Berlin. For everyone else it depends on how you feel about sheep, and I don't know how to do that kind of logic stuff with a spreadsheet. Let's say . . . "If Sheep Lover then true else . . ."

Posted by: Mark at July 3, 2006 06:44 PM

Should those be sheep instead of curses?

Posted by: Cindy at July 3, 2006 12:12 PM