View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JKELSTONE JKELSTONE is offline
external usenet poster
 
Posts: 4
Default Sum a range that IS NOT NULL

Can someone help me with this.. I know it has to be easier than I am making
it for myself. I am trying to SUM a column contingent on another having a
date entered in it (all on the same ROW). I am putting the sum in a colum off
to the right of them both. I don't want to sum the rows without a date and
the dates are always different.

=IF(C3="date",I3*0.8,0)

Something like this and I will be draggin this formula down Column "J", this
is based on two columns the condition is the date, the dollars is in column
"I"

Please help!!
--
JESSY