troubleshooting Question
Match 2 parameters then sum
Dear experts,
I have 4 columns, Column A is "Customer Name", column B is "Invoice Date", Column C is "Invoice Amount" and column D is "Status"
In cell G1 I have a user selected Customer Name. In cell H1 i have user selected month/year.(Jan-11,Feb-11,
I would like the output of this formula to be placed in I1 and the logic is as follows:
If Company name Matches user selection, and invoice date is on the same month as the user selection, and invoice status is NOT rejected, return the sum of invoiced dollars for that business for that month.
Can the above be done with VBA?
TIA
I have 4 columns, Column A is "Customer Name", column B is "Invoice Date", Column C is "Invoice Amount" and column D is "Status"
In cell G1 I have a user selected Customer Name. In cell H1 i have user selected month/year.(Jan-11,Feb-11,
I would like the output of this formula to be placed in I1 and the logic is as follows:
If Company name Matches user selection, and invoice date is on the same month as the user selection, and invoice status is NOT rejected, return the sum of invoiced dollars for that business for that month.
Can the above be done with VBA?
TIA
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.