Function with Multiple Criteria...
 

In the following formula, what does the ",1,0" stand for at the end of
the formula? Also, what does the "Amount" at the end stand for as well.


=SUM(IF((Place="Down")+(Difference<0),1,0)*Amount

Thanks.

Function with Multiple Criteria...
 

1 is what is returned if the "IF" Statement returns true, 0 if false.
Amount appears to be a named range.

HTH

Die_Another_Day
wrote:
In the following formula, what does the ",1,0" stand for at the end of
the formula? Also, what does the "Amount" at the end stand for as well.


=SUM(IF((Place="Down")+(Difference<0),1,0)*Amount

Thanks.

Function with Multiple Criteria...
 

It is used to give the SUM something to add up. The formula is doing a count
in reality, so it sums 1 if the condition is met, 0 if it isn't.

The *Amount at the end seems odd though, and it isn't helped by the fact
that what you posted is incorrect, there is a bracket missing, but if it
should be at the end it makes some sort of sense. But assuming this is so,
multiplying by a number means that the 1,0 is superfluous,
=SUM(IF((Place="Down")+(difference<0),Amount)) works just as well.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
ps.com...
In the following formula, what does the ",1,0" stand for at the end of
the formula? Also, what does the "Amount" at the end stand for as well.


=SUM(IF((Place="Down")+(Difference<0),1,0)*Amount

Thanks.