A
B
C
D
E
F
G
H
I
J
K
L
1
Q3 Cash Plan
2
3
Income
Expenses
4
Planned
Actual
Diff.
Planned
Actual
5
Totals
$4,280.00
$4,615.00
$335
Totals
=SUM
SUM
Adds up a list of numbers or the values in a range of cells.
SUMIF
Adds the values in a range that meet a single condition.
SUMIFS
Adds the values in a range that satisfy several conditions at once.
SUMPRODUCT
Multiplies the matching entries of two or more equally sized ranges, then adds those products together into one result.
6
$0
7
Retainers
$0.00
$0.00
$0
Groceries
$412.00
8
Salary
$4,280.00
$4,615.00
$335
Donations
$0.00
9
Royalties
$0.00
$0.00
$0
Insurance
$0.00
10
Dividends
$0.00
$0.00
$0
Rent
$1,340.00
11
Refunds
$0.00
$0.00
$0
Commute
$86.00
12
Uncategorized
$0.00
$0.00
$0
Wellness
$125.00
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31