Thread: Formula for PDA
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Does =countif() work with Pocket Excel (I have no idea!):

=SUMIF(A2:A13,"Jones",C2:C13)+SUMIF(A2:A13,"rogers ",C2:C13)

Marc Klein wrote:

=SUMPRODUCT(((A2:A13="Jones")+(A2:A13="Rogers"))*
(C2:C13))

This formula doesnot work in pocket excel. Is there an
alternative?


--

Dave Peterson