View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Need help with a SUM formula...

=IF(E280,25,IF(E28=0,-))
--
Gary''s Student - gsnu200756


"Christina" wrote:

Here's the formula I'm using:

=IF(E280,"25",IF(E28=0,-))

The formula is doing exactly what it should. I just want the 25 added into
the sum when applicable.

Thanks!
Christina

"Christina" wrote:

I'm trying to sum up a column but one of the cells in the sum range has an IF
formula in it. I need the total sum to include the value of this cell. When I
do the simple sum formula it doesn't include it in the total. How do I get
this to work for me??

Thanks!