Formula for PDA

M

Marc Klein

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


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

Dave Peterson

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

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