Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    64

    Question Unanswered: sumif functionality

    trying to sum a range of cells by dates without using the cell number.

    here's my example, please advised

    =sumif($07/01/2003$:$07/31/2003$,"salescount", $cost$) getting an error.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: sumif functionality

    getting an error ....

    But what does the error message say ?

    Cheers
    Sathyaram
    Originally posted by comf36
    trying to sum a range of cells by dates without using the cell number.

    here's my example, please advised

    =sumif($07/01/2003$:$07/31/2003$,"salescount", $cost$) getting an error.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2003
    Posts
    64

    I fix the problem but my results is 0, what happen

    =SUMIF(A2:A50,"=INVENTORYTIMES",G2:G50

    the results are 0:00 because their cycle times. I would like it to pull by dates not cell numbers, the spreadsheet is update bi-weekly separate by ranges. Cells G2:G50 are total times and I would like to sum them by dates not cells, like A2:A50

  4. #4
    Join Date
    Aug 2003
    Posts
    64

    Angry getting close

    =SUM(IF("#07/01/03#,#07/31/03#","INVENTORYTIMES",G1)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •