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.