James Elliott - WA Rural Computers wrote:
...
ie. I made it read:
=SUMPRODUCT(chqDEBIT,chqCODE=A13,chqDATE>=$D$4,chqDATE<=$D$5)
and the formula no longer worked! The sumproduct total I had in that
cell just disappeared - no error message, just no result.
If you're working in Calc then you need semicolons instead of commas.
It works for me if I make that change.
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
