G Guest Mar 16, 2005 #1 =SOMPRODUCT(($A$2:$A$132=2)*($C$2:$C$132="j")) doesn't work with pocket excel. Does anyone have an alternative?
=SOMPRODUCT(($A$2:$A$132=2)*($C$2:$C$132="j")) doesn't work with pocket excel. Does anyone have an alternative?
D Dave Peterson Mar 16, 2005 #4 =And() didn't work??? it didn't work either... I find this very strange... Click to expand...