Sum Question

[jdotbonk]

Hello All - am curious if someone knows the formula that would allow me to add up the $ amounts in column B & C off to the side of the worksheet for anything with a Z. That way I can keep a running total of the total Zelle (Z) payments off to the side instead of running a total at the bottom. And if I add any more Z's in column D it would then automatically add the $ amounts to that total.

Attached is an example for reference also.

WINNER'S POT	DONATION POT	Zelle or Venmo
$ 440	$ 135
$ 40.00	$ 10.00	Z
$ 20.00	$ 5.00	Z
$ 20.00	$ 5.00	V
$ 20.00	$ 5.00	V
$ 20.00	$ 5.00	V

Thank you in advance for your help!

Cheers

 

[alansidman]

Book2
	B	C	D	E	F	G
1	WINNER'S POT	DONATION POT	Zelle
2			or
3			Venmo		WinnerT	DonationT
4	$440	$135			60	15
5	$40.00	$10.00	Z
6	$20.00	$5.00	Z
7	$20.00	$5.00	V
8	$20.00	$5.00	V
9	$20.00	$5.00	V
Sheet1

Cell Formulas
Range	Formula
F4	F4	=SUMIF(D4:D9,"Z",B4:B9)
G4	G4	=SUMIF(D4:D9,"Z",C4:C9)