Formula for PDA

  • Thread starter Thread starter Marc Klein
  • Start date Start date
M

Marc Klein

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


This formula doesnot work in pocket excel. Is there an
alternative?
 
Does =countif() work with Pocket Excel (I have no idea!):

=SUMIF(A2:A13,"Jones",C2:C13)+SUMIF(A2:A13,"rogers",C2:C13)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional sum, when condition has multiple values 3
Excel repatation of Formula 8
A formula that autofills by trend rather than linear 1
Finding certain value in a column 2
Entering value in the cell 1
Excel 2007 - SUMIFS formula use between tabs 2
What does using -- in a formula do? 8
Real-time sorting 11

Back
Top