software

I'm trying to sum values that I have returned when using an if statement.
How do I do this? My if statement reads =if(b3=quot;yquot;,$7.00,$0.00).

can someone please help me?

Thanks.SUMIF would be the way to go to sum multiple entries based on a criteria.
Taking a guess I would say something like
=SUMIF(B3:B200,quot;0quot;) would sum all the cells between B3 and B200 that have a
value higher than 0.
You could then just format the cell that holds the SUMIF statement as
currency.

quot;trimattquot; wrote:

gt; I'm trying to sum values that I have returned when using an if statement.
gt; How do I do this? My if statement reads =if(b3=quot;yquot;,$7.00,$0.00).
gt;
gt; can someone please help me?
gt;
gt; Thanks.
gt;

Format the cell a currency and change your formula to:

=IF(B3=quot;yquot;,7,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland

with @tiscali.co.ukquot;trimattquot; gt; wrote in message
...
gt; I'm trying to sum values that I have returned when using an if statement.
gt; How do I do this? My if statement reads =if(b3=quot;yquot;,$7.00,$0.00).
gt;
gt; can someone please help me?
gt;
gt; Thanks.
gt;