VLOOKUP IF AND Function - Need Help

[afont41]

I need to pull data from 4 columns for ticket sales. The columns include:
- Date of Purchase
- Amount Paid
- Event Date
- Payment Method

I am trying to pull the amount paid based on the event date, date of purchase, and payment method to create general journal entries.

For example - I need to pull the total amount paid on 2/25/2015 by Visa, MasterCard, Discover for an event on 2/27/2014. Please advise if I should post the data if it would help with answering my question.

 

[Mackers]

If the date/event/payment combination is unique (i.e. there will only ever be one payment on 25/02/2015 by Visa for an event on 27/02/2014), then you can use SUMIFS(), which will be a lot faster. The format is:

=sumifs(AmountColumn, DateofPurchColumn, ReqDateofPurch, EventDateColumn, ReqEventDate, PaymentMethodColumn, ReqPaymentMethod)

Where Req = required, so ReqDateofPurch in this case points to a cell containing the date 25/02/2015, ReqPaymentMethod points to a cell containing the string "Visa" etc.

Does that make sense? Edit: if you are unsure then pasting some data might be helpful.