Hi, I am looking to create a summary for cash, card and cheque payments from a table on a separate tab for each receipt codes.
I would basically just like a total for each of the receipt codes for each of the payment methods but cannot figure this out due to there being 3 different payment types so it's not just a simple IF formula.
I would like the summary to be on the table on the 'Banking Sheet 1'. All the info is generated from the 'Payment details' sheet. On the 'Payment Details' sheet, both the 'Payment method' and 'receipt code' columns contain a drop down list of options.