Formula PDA

[marciemar]

Can somebody tell me what if this formula has
alternitives because this doesn't work on my PDA (pocket
excel).

=SUMPRODUCT((sheet1!$A$2:$A$132=2)*(sheet1!
$C$2:$C$132="J"))

 

[Bob Phillips]

Does it support array formula? If so, perhaps

=SUM(IF(sheet1!$A$2:$A$132=2,IF(sheet1!$C$2:$C$132="J",1,0),0))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

That didn't work either. I finf it strange that tese
formula's aren't compatible with pocket excel.

Thsi is the on I need to get into my pda...

=SOMPRODUCT(($A$2:$A$132=2)*($C$2:$C$132="j"))

Greetings

 

[Dave Peterson]

I've never used pocket excel, but just from the name, I'd bet lots of
functionality is lost. (I don't find it strange at all <g>.)

Can you just add another column and then use that?

=if(and(a2=2,c2="j"),1,0)

And drag down.

Then sum that helper column.