Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Sumif function or macro (https://www.askmehelpdesk.com/showthread.php?t=390268)

  • Aug 25, 2009, 05:25 AM
    santoshdream
    Sumif function or macro
    Hi,

    Need yor help.

    I have two sheets
    1. Tracker
    2. Data


    I have to update my GL Balance(CAD) "H Col0umn" in Tracker Sheet, for that I will take my total sum from Sum Transaction Amt from "F Coloumn" sheet2 "DATA".


    My condition is

    If Bus Unit,Account,Department,Affiliate,Product in Tracker Sheet are matching with my Data sheet then I will copy the Total Sum from "Sum Transaction Amt"(F Coloumn) and

    Paste it to GL Balance(CAD) "H Col0umn" in Tracker Sheet.

    I have to update Tracker sheet from serial 1 to 44 on a daily basis.


    I would appreciate if you could help me for the same. Please find the step and the attachment for reference.


    Thanks & Regards

    Santosh
  • Aug 26, 2009, 12:43 AM
    JBeaucaire

    I can help you if you click on GO ADVANCED and use the paperclip to upload your sample sheet.

    Make sure your sample sheet includes sample results too, make sure I can see exactly where your answers came from if it's not obvious.
  • Aug 26, 2009, 11:43 PM
    santoshdream
    Hi,

    My file size is heavy. I would appreciate if you could provide me the email address.

    Regards
  • Aug 27, 2009, 12:01 AM
    santoshdream
    1 Attachment(s)
    Hi
    Find the attached.

    Regards
  • Aug 27, 2009, 12:05 AM
    santoshdream
    2 Attachment(s)
    Find the attached step

    Regards
  • Aug 27, 2009, 12:31 AM
    JBeaucaire
    1 Attachment(s)

    This is the formula needed H2 and copied down:

    =INDEX(DATA!$F2:$F$200, MATCH(B2&"-"&C2&"-"&D2&"-"&E2&"-"&F2, INDEX(DATA!$A$2:$A$200&"-"&DATA!$B$2:$B$200&"-"&DATA!$C$2:$C$200&"-"&DATA!$E$2:$E$200&"-"&DATA!$D$2:$D$200, 0), 0))

    I know it's the right formula, but the sheet you uploaded did not have a single item in it matching your criteria. I had to copy the values from row 2 into the DATA sheet somewhere to have it find the value and return it.

  • All times are GMT -7. The time now is 01:20 PM.