Hi, Quick question;
I have a name that I'm referencing in column G655 for a drop down list used in the spreadsheet. I want to summarize all the transactions associated with the name in column H655, based on the range of data in Column AN, rows 11 to 655, only if the name matches what's in Column AS for the same row.
How would this be constructed in a formula, or would I need to use a macro instead?
I appreciate any help.
I have a name that I'm referencing in column G655 for a drop down list used in the spreadsheet. I want to summarize all the transactions associated with the name in column H655, based on the range of data in Column AN, rows 11 to 655, only if the name matches what's in Column AS for the same row.
How would this be constructed in a formula, or would I need to use a macro instead?
I appreciate any help.