Ask Experts Questions for FREE Help !
Ask
    santoshdream's Avatar
    santoshdream Posts: 11, Reputation: 1
    New Member
     
    #1

    Aug 25, 2009, 05:25 AM
    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
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Aug 26, 2009, 12:43 AM

    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.
    santoshdream's Avatar
    santoshdream Posts: 11, Reputation: 1
    New Member
     
    #3

    Aug 26, 2009, 11:43 PM
    Hi,

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

    Regards
    santoshdream's Avatar
    santoshdream Posts: 11, Reputation: 1
    New Member
     
    #4

    Aug 27, 2009, 12:01 AM
    Hi
    Find the attached.

    Regards
    Attached Files
  1. File Type: zip part1.zip (5.1 KB, 63 views)
  2. santoshdream's Avatar
    santoshdream Posts: 11, Reputation: 1
    New Member
     
    #5

    Aug 27, 2009, 12:05 AM
    Find the attached step

    Regards
    Attached Files
  3. File Type: zip step1.zip (59.8 KB, 58 views)
  4. File Type: zip step2.zip (70.5 KB, 105 views)
  5. JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #6

    Aug 27, 2009, 12:31 AM

    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.
    Attached Files
  6. File Type: xls santoshdream-part1.xls (34.5 KB, 183 views)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel Macro [ 13 Answers ]

I have some code that loops through a row and a column and compares data. When it finds the values being equal it copies the columns the row is in and pastes it on another sheet along with the previous value of the column. For Each CCell In Range("C2:C65418") If Not IsEmpty(CCell.Value)...

Macro help [ 3 Answers ]

Hi all, I am currently working with a dataset where the data in column A is empty until a user enters a rank (i.e. like ranking grades in ascending order). Currently the macro takes the number and moves the row entry to the top by assuming that the rank is to be the highest rank (it then takes...

The result of increasing and decreasing function on the composite function [ 6 Answers ]

I was asked to prove the result of increasing and decreasing function on the composite function... prove that: 1- if f(X) inc & g(X) inc, foG inc 2-if F(X) inc & G(X) dec, foG dec 3- if F(X) dec & G(X) inc, fog dec 4- if f(X) dec & G(X) dec, fog inc please help me in that

SUMIF with 2 criteria [ 2 Answers ]

Hello All, I'm relatively new to using functions in excel and I'm sure my problem is really very simple but I am having a hard time figuring it out. I want to use the SUMIF function to total column C but only if column A=4012 and if column B=UK. A B C G/L...


View more questions Search