OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[SOLVED]Need help with formula

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
DriverJim
General User
General User


Joined: 23 Jun 2012
Posts: 10

PostPosted: Sat Jun 23, 2012 5:37 am    Post subject: [SOLVED]Need help with formula Reply with quote

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
Back to top
View user's profile Send private message
ozzie
OOo Advocate
OOo Advocate


Joined: 29 Jul 2010
Posts: 397
Location: victoria

PostPosted: Sat Jun 23, 2012 10:00 pm    Post subject: Reply with quote

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

_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
karolus
OOo Advocate
OOo Advocate


Joined: 22 Jun 2011
Posts: 210

PostPosted: Sat Jun 23, 2012 11:10 pm    Post subject: Reply with quote

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


Karo
Back to top
View user's profile Send private message
DriverJim
General User
General User


Joined: 23 Jun 2012
Posts: 10

PostPosted: Sun Jun 24, 2012 4:30 pm    Post subject: [SOLVED]Need help with formula Reply with quote

Awesome! Thanks for the help. Works perfectly.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group