Forum Discussion
Greg Nix
Jun 13, 2017Copper Contributor
Excel Formula Help
I am creating a spreadsheet to keep a running total on expenditures from different accounts and cannot figure out a formula to automatically show the balance. I have a column where I input the acco...
SergeiBaklan
Jun 13, 2017Diamond Contributor
Hi Greg,
Perhaps that's something like
=B2-SUMIF(A5:A500,"xxxx.A",I5:I500)
if i understood you correctly
Greg Nix
Jun 14, 2017Copper Contributor
Sergei,
Your formula worked perfect. I had all the components there, just not in the correct order. Thank you for the help...