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
|