Populate the "amount" columns based off of certain criteria

[MNexcel]

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!

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​

 

[etaf]

does the following do what you want

Book1
	A	B	C	D	E	F	G
1	Payment Type	Chargeback Amt	Customer ID		GTD	NG	CB
2	American Express	-51.8	614474475228751000		-25	-1253.62	-1
3	Discover	-16	745268008223924000
4	Discover	-16.95	750028235793892000
5	Electronic Check	-25
6	Electronic Check	-1253.62	733855724702287000
7	MasterCard	-26.87	752868452826416000
8	VISA	-15	746352609481368000
9	VISA	120	743955403115242000
10	VISA	-25	752905043308578000
11	Other	-1
Sheet1

Cell Formulas
Range	Formula
E2	E2	=SUMIFS(B2:B10,A2:A10,"Electronic Check",C2:C10,"")
F2	F2	=SUMIFS(B2:B10,A2:A10,"Electronic Check",C2:C10,"<>")
G2	G2	=SUMIFS(B:B,A:A,"<>electronic check",A:A,"<>american express",A:A,"<>discover",A:A,"<>mastercard",A:A,"<>visa")

 

[MNexcel]

The only thing I am finding wrong with this is this formula should be containing all things but "Electronic Checks". The amount that should populate from this would be -31.62. Any thoughts?

G2

G2

=SUMIFS(B:B,A:A,"<>electronic check",A:A,"<>american express",A:A,"<>discover",A:A,"<>mastercard",A:A,"<>visa")

 

[MNexcel]

I corrected it with the below formula since it's all cc types and electronic checks..

=(SUMIFS(M2:M128,F2:F128,"<>electronic check"))*-1

 

[MNexcel]

Another random question too. I'm looking to have a value input whether it's less than -99.99 or greater than 99.99 and matches a specific name, for the sake of this, let's say it's my username. Here is the formula I've got thus far, but how do I incorporate also ensuring it pulls in the value if it's less than -99.99 or greater than 99.99. Any thoughts on this?

=(SUMIFS(M2:M5,AA2:AA5,"=MNexcel"))*-1

 

[etaf]

sorry not following, it may also be best to start a new thread , as its a new question, more members will view then