Formula pocket excel
 

=SOMPRODUCT(($A$2:$A$132=2)*($C$2:$C$132="j")) doesn't work with pocket
excel. Does anyone have an alternative?

You didn't like that other suggestion to your post in .misc?

Marciemar wrote:

=SOMPRODUCT(($A$2:$A$132=2)*($C$2:$C$132="j")) doesn't work with pocket
excel. Does anyone have an alternative?

--

Dave Peterson

:) it didn't work either... I find this very strange...

-----Original Message-----
You didn't like that other suggestion to your post
in .misc?

Marciemar wrote:

=SOMPRODUCT(($A$2:$A$132=2)*($C$2:$C$132="j")) doesn't
work with pocket
excel. Does anyone have an alternative?

--

Dave Peterson
.

=And() didn't work???


wrote:

:) it didn't work either... I find this very strange...

-----Original Message-----
You didn't like that other suggestion to your post
in .misc?

Marciemar wrote:

=SOMPRODUCT(($A$2:$A$132=2)*($C$2:$C$132="j")) doesn't
work with pocket
excel. Does anyone have an alternative?

--

Dave Peterson
.


--

Dave Peterson