[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
DriverJim
General User

Joined: 23 Jun 2012
Posts: 10

 Posted: Sat Jun 23, 2012 5:37 am    Post subject: [SOLVED]Need help with formula What I'm trying to do is total cash withdrawls/deposits on a daily budget planner and where to get them to display. I know the basics of the formula, as B goes from 23-215, same with F and G. The setup I want is so the cash is seperated from everything else (Checks, Cards, EFTs and whatnot). Allow me to expound on this. I want the associated instances of a word ("Cash") in Column B to either add to (Column F, Withdrawls) or subtract (Column G, Deposits) from my Cash On Hand. I can do this across seperate sheets but not on the same one. Last edited by DriverJim on Sun Jun 24, 2012 4:32 pm; edited 1 time in total
ozzie

Joined: 29 Jul 2010
Posts: 402
Location: victoria

Posted: Sat Jun 23, 2012 10:00 pm    Post subject:

 Code: =SUMIF(\$B\$23:\$B\$215;"cash";\$G\$23:\$G\$215)-SUMIF(\$B\$23:\$B\$215;"cash";\$F\$23:\$F\$215)

_________________
karolus

Joined: 22 Jun 2011
Posts: 210

Posted: Sat Jun 23, 2012 11:10 pm    Post subject:

Hallo
Or:
 Code: =SUMPRODUCT( \$B\$23:\$B\$215="cash" ; \$G\$23:\$G\$215-\$F\$23:\$F\$215)

Karo
DriverJim
General User

Joined: 23 Jun 2012
Posts: 10

 Posted: Sun Jun 24, 2012 4:30 pm    Post subject: [SOLVED]Need help with formula Awesome! Thanks for the help. Works perfectly.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum