Adding Each If Statement Together

[MrNerd]

I am doing a personal budget and wanted I40 and I41 to add together if the 25th of the month fell on a Saturday.

	H	I	J
40	Car	$445	25
41	Groceries/Gas	$150	Saturday

<tbody>
</tbody>

​

Below you can see on the 25th of the month (Saturday) the $445 took (I27) but not adding in the $150 (below that is the formula held in I27). Not sure what I am missing.

	G	H	I	J
2			Money Out	Money In
3	1	Wednesday	$ -
4	2	Thursday	0
5	3	Friday	0
6	4	Saturday	$ 150
7	5	Sunday	$ -
8	6	Monday	0
9	7	Tuesday	0
10	8	Wednesday	0
11	9	Thursday	$ -
12	10	Friday	0
13	11	Saturday	$ 150
14	12	Sunday	0
15	13	Monday	0
16	14	Tuesday	0
17	15	Wednesday	$ -
18	16	Thursday	0
19	17	Friday	0
20	18	Saturday	$ 150
21	19	Sunday	0
22	20	Monday	0
23	21	Tuesday	0
24	22	Wednesday	0
25	23	Thursday	0
26	24	Friday	0
27	25	Saturday	$ 445
28	26	Sunday	0
29	27	Monday	0
30	28	Tuesday	0
31	29	Wednesday	0
32	30	Thursday	$ -
33	31	Friday	0
34
35
36		Expenses		Day of the Month
37		Cell Phone	$0	5
38		KCPL	$0	9
39		Mortgage/Insurance	$0	15
40		Car	$445	25
41		Groceries/Gas	$150	Saturday

<tbody>
</tbody>

2018​

	I
27	$ 445

<tbody>
</tbody>

2018​

Worksheet Formulas Cell Formula I27 =IF(G27=$J$37,$I$37,IF(G27=$J$38,$I$38,IF(G27=$J$39,$I$39,IF(G27=$J$40,$I$40,IF(G27=$J$43,$I$43,IF(H27=$J$41,$I$41,IF(G27=$J$42,$I$42,"0"))))))) <tbody> </tbody>

<tbody>
</tbody>

 

[Special-K99]

Once an IF condtion becomes TRUE the rest of the formula doesnt get executed.
So if G27=J37 the result will be I37... and nothing else will get executed in that formula.

Here's a different way of doing it.
=(G27=J37)*I37+(G27=J38)*I38+(G27=J39)*I39+(G27=J40)*I40+(G27=J43)*I43+(H27=J41)*I41+(G27=J42)*I42

Each part in brackets evaluates to TRUE (1) or FALSE (0)
This is then muliplied by the value in column I, then the whole lot is added together.

 

[MrNerd]

Perfect!!!