TheDigest Sat, 13 Feb 2010, Volume 02, Number 1482


Sent to: 568 subscribers

In today's TheDigest 01 message
============================

Topics

  1. Re: Lack of COUNTIF

   *++++++++++&  > 

Date: 11 Feb 2010 13:38:37 +0000
From: Cathy Roberts <address truncated>
Subject: Re: Lack of COUNTIF


Peter McCafferty  wrote

CountIF isn't an active function in Psion Sheet, does anyone know an
alternative method?

Oddly enough I had been reading through some back issues of Palmtop recently (Issue 26 to be exact) & had seen Steve Litchfield's article on using Sheet to track lottery winners! He did it by a 2-stage method, using plain "if" to see if the cell in question matched the criteria, getting it to put "1" if it did, & then adding up the total afterwards. Longwinded but it does work.
 
Cheers
Cathy      

*++++++++++&


2