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="y",$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,"0") 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.

"trimatt" wrote:

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="y",$7.00,$0.00).

can someone please help me?

Thanks.

Format the cell a currency and change your formula to:

=IF(B3="y",7,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"trimatt" wrote in message
...
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="y",$7.00,$0.00).

can someone please help me?

Thanks.