Good afternoon,
I am hoping to find some help with creating a formula to help pull in criteria that is needed to help save me some time from formatting to pull in data.
Essentially, in the attached sheet you have the fields and list listed below: Gtd, NG, and CB and I have to the cell of the right of them the data that I would like pulled into the cell to the right of those.
I did try doing a SUMIF, IF, and even attempted an AND formula within an SUMIF formula but I couldn't perfect it so I couldn't get it to be effective.
Also, I was hoping as some of these sheets I struggle with building if anyone has any tips with what could help my growth in this as I like building things like this to help some of my stuff.
Please let me know if anything else is needed.
Thanks for all the help!
I am hoping to find some help with creating a formula to help pull in criteria that is needed to help save me some time from formatting to pull in data.
Essentially, in the attached sheet you have the fields and list listed below: Gtd, NG, and CB and I have to the cell of the right of them the data that I would like pulled into the cell to the right of those.
I did try doing a SUMIF, IF, and even attempted an AND formula within an SUMIF formula but I couldn't perfect it so I couldn't get it to be effective.
Also, I was hoping as some of these sheets I struggle with building if anyone has any tips with what could help my growth in this as I like building things like this to help some of my stuff.
Please let me know if anything else is needed.
Thanks for all the help!
Gtd | consists of the value that has "electronic check" and NO value found in the "customer ID" column |
NG | consists of the value that has "electronic check" and values in the "customer ID" in column C |
CB | anything other than electronic check: American Express, Discover, MasterCard, and Visa |
Payment Type | Chargeback Amt | Customer ID |
American Express | -51.8 | 614474475228751000 |
Discover | -16 | 745268008223924000 |
Discover | -16.95 | 750028235793892000 |
Electronic Check | -25 | |
Electronic Check | -1253.62 | 733855724702287000 |
MasterCard | -26.87 | 752868452826416000 |
VISA | -15 | 746352609481368000 |
VISA | 120 | 743955403115242000 |
VISA | -25 | 752905043308578000 |