On Wed, 13 Feb 2008 06:14:46 -0800 (PST), DoooWhat
wrote:

The following formula calculates correctly on my work PC, but not on
my home PC. Do you know the reason behind this? What can I do to fix
it? Any help will be much appreciated.

=IF(COUNTIF('Cash Flows'!$C$2:$C$50000,$A1)=0,0,
(SUMPRODUCT((MAX(('Cash Flows'!$A$2:$A$50000)*('Cash Flows'!$C$2:$C
$50000=$A1))))-SUMPRODUCT(SMALL(('Cash Flows'!$A$2:$A$50000)*('Cash
Flows'!$C$2:$C$50000=$A1),(COUNTIF('Cash Flows'!$C$2:$C$50000,"<"&
$A1)+1)-COUNTIF('Cash Flows'!$C$2:$C$50000,$A1))))+1)

Kevin

Assuming the formulas are the same, but the results are different, then there
is a difference either in your data or in the manner in which Excel is
interpreting your data.

But I'm not very good at mind-reading. You described neither what you mean by
functioning incorrectly, nor the type of data you are inputting to the formula.

Perhaps you have a different date system on the two PC's; perhaps one is set to
use Lotus transition?

Perhaps you could rephrase your question and supply relevant information?
--ron