| View previous topic :: View next topic |
| 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 |
|
| Back to top |
|
 |
ozzie
OOo Advocate
Joined: 29 Jul 2010
Posts: 316
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) |
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button). |
|
| Back to top |
|
|
karolus
OOo Advocate
Joined: 22 Jun 2011
Posts: 208
|
| 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 |
|
| Back to top |
|
|
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. |
|
| Back to top |
|
|
|
