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.
Thank you in advance for your help!
Cheers
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