Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Formula is not calculating (https://www.askmehelpdesk.com/showthread.php?t=243084)

  • Jul 29, 2008, 02:59 PM
    gilda102
    Formula is not calculating
    I have two worksheets, the first one is titled 'Daily Log' the other is 'Annual Summary'
    Column C on the log worksheet contains G/L codes. Column H contains pledge amounts.
    On the summary worksheet I would like to add all of the pledges for each specific G/L code. The formula I am using was taken from another workbook created by someone else. The formula works just fine on that workbook but not on mine. I've already checked that calculation is set to automatic. I've also tried making the formula an array formula.
    The formula is: =SUM(IF('Daily Log'!C2:C100="4010",'Daily Log'!H2:H100))
  • Jul 29, 2008, 05:31 PM
    KISS
    Is the GL code a string or a number? It looks like this formla expects the gl code to be a string.

    Temporarily change any C entry of 4010 to '4010 and see if it works. Note the single quote.
  • Jul 29, 2008, 08:02 PM
    JBeaucaire
    1 Attachment(s)
    Use names to simplify your process.

    • On Daily Log, highlight cells C2:C100, then NAME the range PLCODES
      (Just above column A is a white box you can type that name in directly)
    • Highlight H2:H100 and NAME the range PLEDGE
    • On sheet two, your formula is:
      {=SUM(IF(PLCode=4010,Pledge))}

    This only works when you CTRL-SHIFT-ENTER the formula to properly activate the array.

  • All times are GMT -7. The time now is 05:53 AM.