Sum a range that IS NOT NULL

  • Thread starter Thread starter JKELSTONE
  • Start date Start date
J

JKELSTONE

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!!
 
This does work, if I take my columns and paste them values only into a blank
spreadsheet, then format them Dates and Currency like they are in my Master.
So, there must be something with my Master Spreadsheet that is messing with
the formula

Thank you!!
 
You are welcome

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

JKELSTONE said:
This does work, if I take my columns and paste them values only into a
blank
spreadsheet, then format them Dates and Currency like they are in my
Master.
So, there must be something with my Master Spreadsheet that is messing
with
the formula

Thank you!!
Click to expand...
 
=COUNT(C3)*I3*0.8
The Count function did not work
Click to expand...
=isnumber(C3)*I3*0.8
This does work
Click to expand...

Hmmm...

It's not possible that the COUNT version *didn't* work while the ISNUMBER
version did work. Both of those formulas do the same thing but in a
different way.

COUNT will return either 1 or 0
ISNUMBER will return either TRUE or FALSE

In a calculation TRUE and FALSE are the equivalent of 1 and 0.

So, both formulas will return exactly the same result under *every*
condition.
 
Back
Top