home *** CD-ROM | disk | FTP | other *** search
/ Home Office Executive / QuantumAxcess-HomeOfficeExecutiveForWindows-Win31.iso / lotus / csum / csum.exe / CSUMREAD.ME < prev   
Text File  |  1993-06-29  |  2KB  |  63 lines
  1.  
  2.  
  3.                        @CSUM()
  4.                      Cumulative Sum
  5.                       Gary Miller
  6.                       72657,3010
  7.                        6/29/93
  8.  
  9.  
  10.  
  11.         @CSUM() is a LOTUS 123 Release 2.x addon @ function that can be
  12. used to sum the first n values of a given column or row. Rather than
  13. changing an @SUM() formula every month for comparable totals or the
  14. somewhat clumsy @DSUM() example shown I use @CSUM().
  15.  
  16.         Syntax is      @CSUM(n,range)
  17.                     
  18.  
  19.         A        B        C        D        E        F        G        H
  20. 1   Month                               29-Jun-93
  21. 2          1 +A5<=@COUNT($D$5..$D$16)
  22. 3
  23. 4     Month              "1992    "1993
  24. 5          1 Jan           234       23
  25. 6          2 Feb            34        2                                         
  26. 7          3 Mar             5       33                                         
  27. 8          4 Apr            45       44                                         
  28. 9          5 May             4       56                                         
  29. 10         6 Jun             5        1                                         
  30. 11         7 Jul            23                                                  
  31. 12         8 Aug             5                                                  
  32. 13         9 Sep            45                                                  
  33. 14        10 Oct            17                                                  
  34. 15        11 Nov           130                                                  
  35. 16        12 Dec           215                                                  
  36. 17                                                                              
  37. 18                         327 @DSUM(A4..D16,2,A1..A2)
  38.                           
  39. 19                         327 @CSUM(6,C5..C16)
  40. 20                         327 @CSUM(@COUNT(D5..D16),C5..C16)
  41. 21                         327 @CSUM(@MONTH(E1),C..C16)
  42.  
  43.  
  44.  
  45.  
  46.  
  47.  
  48.  
  49.         Copyright (c) 1993 Gary R. Miller .  All Rights Reserved.
  50.    
  51.  You are free to use, copy and distribute @CSUM() providing that:
  52.  
  53.      NO FEE IS CHARGED FOR USE, COPYING OR DISTRIBUTION.
  54.    
  55.      IT IS NOT MODIFIED IN ANY WAY.
  56.    
  57.      THIS DOCUMENTATION FILE (UNMODIFIED) ACCOMPANIES ALL COPIES.
  58.    
  59.  This program is provided AS IS without any warranty, expressed or
  60.  implied, including but not limited to fitness for a particular purpose.
  61.  
  62.                       
  63.