How can I improve existing formula

[Sean15]

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

 

[vogel997]

			Formula in column "C"
Beginning balance - all locations		0
Cam deposits		0.00	=SUMIFS($D$6:$D$28,$B$6:$B$28,A31)
GL Receipts		0.00	=SUMIFS($D$6:$D$28,$B$6:$B$28,A32)
Ag Receipts		0	=SUMIFS($D$6:$D$28,$B$6:$B$28,A33)
Less: NSFs		0.00	=SUMIFS($D$6:$D$28,$B$6:$B$28,A34)
Credit card recipts		0	=SUMIFS($D$6:$D$28,$B$6:$B$28,A35)
Credit card chargebacks		0	=SUMIFS($D$6:$D$28,$B$6:$B$28,A36)
Credit card fees		0	=SUMIFS($D$6:$D$28,$B$6:$B$28,A37)
Adjustments		0	=SUMIFS($D$6:$D$28,$B$6:$B$28,A38)
Transfer to main		0.00	=SUMIFS($D$6:$D$28,$B$6:$B$28,A39)
Ending balance - all locations		0
			It only works for row 31 if you change Camp to Cam!!
			Try this

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

 

[Sean15]

@vogel997:

I believe cell reference $D$6:$D$28 should be $C$6:$C$28 and $B$6:$B$28 should be $A$6:$A$28 but formula works very well. Thank you very much.

Could formula be made to reference date in C2?

Sean

 

[Sean15]

any ideas?

Thanks,

Regards,

Sean