ExcelBanter - Formula for PDA

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula for PDA (https://www.excelbanter.com/excel-discussion-misc-queries/17587-formula-pda.html)

Marc Klein

Formula for PDA

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

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

Dave Peterson

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

All times are GMT +1. The time now is 08:34 AM.