2 Replies Latest reply: May 5, 2014 1:24 PM by Massimo Grossi RSS

    Including Null Values

    David Young

      I have the following data set:

       

      U-Date            Amount

      7/8/2013         2280.00

      -                      2227.50

      10/24/2013     2475.00

      -                      2475.00

      6/24/2008        2475.00

       

      I want to sum the amounts of U-Date greater than 7/1/2013 and include the - values.  I have tried different formulas and it is not working.  Any suggestions?

       

      David