if statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Format the cell a currency and change your formula to:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top