theos27
asked on
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, etc.).
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please upload you file.
Please upload your file.
ASKER
Correction, I mean can the above be done without VBA. Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
None