Sean15
Well-known Member
- Joined
- Jun 25, 2005
- Messages
- 698
- Office Version
- 2010
- Platform
- Windows
Excel 2010 | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Thursday | ||||
2 | Description | Account | 6/30/2016 | ||
3 | |||||
4 | |||||
5 | Lighthouse1 | ||||
6 | Beginning balance | 0.00 | |||
7 | Cam deposits | 7,524.00 | |||
8 | GL Receipts | ||||
9 | Ag Receipts | ||||
10 | Less: NSFs | ||||
11 | Credit card recipts | ||||
12 | Credit card chargebacks | ||||
13 | Credit card fees | ||||
14 | Adjustments | ||||
15 | Transfer to main | (7,524.00) | |||
16 | Ending balance | 0.00 | |||
17 | |||||
18 | Cavemill1 | ||||
19 | Beginning balance | 0.00 | |||
20 | Cam deposits | ||||
21 | Ag Receipts | 12,500.00 | |||
22 | Less: NSFs | ||||
23 | Credit card receipts | 1,200.00 | |||
24 | Credit card chargebacks | (752.00) | |||
25 | Credit card fees | ||||
26 | Adjustments | ||||
27 | Transfer to main | (12,948.00) | |||
28 | Ending balance | 0.00 | |||
29 | |||||
30 | Beginning balance - all locations | 0.00 | |||
31 | Camp deposits | 7,524.00 | |||
32 | GL Receipts | 12,500.00 | |||
33 | Ag Receipts | 0.00 | |||
34 | Less: NSFs | 1,200.00 | |||
35 | Credit card recipts | (752.00) | |||
36 | Credit card chargebacks | 0.00 | |||
37 | Credit card fees | 0.00 | |||
38 | Adjustments | 0.00 | |||
39 | Transfer to main | (20,472.00) | |||
40 | Ending balance - all locations | 0.00 | |||
Numbers |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C1 | =TEXT(C2,"dddd") | |
C2 | =Main!C3 | |
C15 | =-SUM(C6:C14) | |
C16 | =SUM(C6:C15) | |
C27 | =-SUM(C19:C26) | |
C28 | =SUM(C19:C27) | |
C31 | =C7+C20 | |
C32 | =C8+C21 | |
C33 | =C9+C22 | |
C34 | =C10+C23 | |
C35 | =C11+C24 | |
C36 | =C12+C25 | |
C37 | =C13+C26 | |
C38 | =C14+C26 | |
C39 | =C15+C27 | |
C40 | =SUM(C30:C39) |
Hello:
I'm trying to improve the formula in C31 to C39.
I thought of SUMIFS but I can't figure out the range for criteria 2 (date in C2)
Could you help please.
Regards,
Sean