Thread: 1001 Books to Read Before You Die
View Single Post
Old 12-22-2008, 01:19 PM   #58
lilac_jive
Grand Sorcerer
lilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud oflilac_jive has much to be proud of
 
lilac_jive's Avatar
 
Posts: 5,870
Karma: 27376
Join Date: Dec 2008
Location: Pennsylvania
Device: PRS-505
Quote:
Originally Posted by jplumey View Post
I went through to see how many I had read, but it was taking too long to count. To solve this problem, I created a new column to count the number of times the word YES appeared in a the 'Read' Column using the following formula:

=COUNTIF(C2:C1001,"=YES") where column C is a column called 'Read?'

It's just a simple way to count the number I've read. I've since redacted your original list and started to add my own contents.

Thanks for the head start!
Ahh thats how you do it. I forgot about the countif function.

I just sorted alphabetically backwards and counted from there.
lilac_jive is offline   Reply With Quote