P
Pantryman
Re: http://www.excelforum.com/showthread.php?t=269850
With help of the people here I found a solution for my counting proble
(I'm excel greenie) but since I use Sun StarOffice I get an error fo
the formula.
The Excel solution is
=SUMPRODUCT(--(A31:A5000>TODAY()-90),--(F31:F5000=E17),M31:M5000)
but this gives a 510 error for the two minuses.
Could someone help me with the way I should put this in StarOffic
Calc?
Thanks in advance,
Marinus
With help of the people here I found a solution for my counting proble
(I'm excel greenie) but since I use Sun StarOffice I get an error fo
the formula.
The Excel solution is
=SUMPRODUCT(--(A31:A5000>TODAY()-90),--(F31:F5000=E17),M31:M5000)
but this gives a 510 error for the two minuses.
Could someone help me with the way I should put this in StarOffic
Calc?
Thanks in advance,
Marinus