usnapoleon
Board Regular
- Joined
- May 22, 2014
- Messages
- 107
- Office Version
- 365
- Platform
- Windows
I am trying to get a formula that looks over a whole page of data, and pulls just 1 number based on some matching criteria. The name in column A, the 'Total:' in column B, and it reports the 'total' amount based on wherever 'total' is in row 8
I have this sample here. Overall, there's more groups than just 'Exchange', I just wanted to keep this visually simple. And I want to account for Total in column J possibly moving to different columns in case the data provided ever changes - so if they add a column and Total goes from Column J to column K instead, I want this formula to be able to catch it.
I have used SumIf and Index before when trying to match certain criteria, but I wasn't sure how to approach this one.
Thanks!
06.24 Reconciliation Report.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
8 | Method | Type | Sales Tickets | Sales Ticket.Fee | Sales Sum | Refunds Tickets | Refunds Ticket.Fee | Refunds Sum | Total | |||
9 | Exchange | CreditCard | VISA | $5.00 | $0.00 | $5.00 | $0.00 | $0.00 | $0.00 | $5.00 | ||
10 | Exchange | Total: | $5.00 | $0.00 | $5.00 | $0.00 | $0.00 | $0.00 | $5.00 | |||
Report_ReconciliationReport_7-1 |
I have this sample here. Overall, there's more groups than just 'Exchange', I just wanted to keep this visually simple. And I want to account for Total in column J possibly moving to different columns in case the data provided ever changes - so if they add a column and Total goes from Column J to column K instead, I want this formula to be able to catch it.
I have used SumIf and Index before when trying to match certain criteria, but I wasn't sure how to approach this one.
Thanks!