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"))

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)


"marciemar" wrote in message
...
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"))

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

-----Original Message-----
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)


"marciemar" wrote
in message
...
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"))



.

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.

wrote:

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

-----Original Message-----
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)


"marciemar" wrote
in message
...
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"))



.


--

Dave Peterson