I am doing a personal budget and wanted I40 and I41 to add together if the 25th of the month fell on a Saturday.
[TABLE="class: cms_table"]
<tbody>[TR]
[TH="align: center"][/TH]
[TH="align: center"]H[/TH]
[TH="align: center"]I[/TH]
[TH="align: center"]J[/TH]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD]Car[/TD]
[TD="align: right"]$445[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD]Groceries/Gas[/TD]
[TD="align: right"]$150[/TD]
[TD="align: center"]Saturday[/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="class: cms_table"]
<tbody>[TR]
[TH="align: center"][/TH]
[TH="align: center"]G[/TH]
[TH="align: center"]H[/TH]
[TH="align: center"]I[/TH]
[TH="align: center"]J[/TH]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]Money Out[/TD]
[TD]Money In[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]1[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Thursday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]3[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]4[/TD]
[TD]Saturday[/TD]
[TD="align: right"]$ 150[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]5[/TD]
[TD]Sunday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]6[/TD]
[TD]Monday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]7[/TD]
[TD]Tuesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]8[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: right"]9[/TD]
[TD]Thursday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: right"]10[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"]11[/TD]
[TD]Saturday[/TD]
[TD="align: right"]$ 150[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]12[/TD]
[TD]Sunday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: right"]13[/TD]
[TD]Monday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: right"]14[/TD]
[TD]Tuesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: right"]15[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: right"]16[/TD]
[TD]Thursday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: right"]17[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: right"]18[/TD]
[TD]Saturday[/TD]
[TD="align: right"]$ 150[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: right"]19[/TD]
[TD]Sunday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: right"]20[/TD]
[TD]Monday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: right"]21[/TD]
[TD]Tuesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: right"]22[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: right"]23[/TD]
[TD]Thursday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: right"]24[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="align: right"]25[/TD]
[TD]Saturday[/TD]
[TD="align: right"]$ 445[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD="align: right"]26[/TD]
[TD]Sunday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="align: right"]27[/TD]
[TD]Monday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: right"]28[/TD]
[TD]Tuesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD="align: right"]29[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD="align: right"]30[/TD]
[TD]Thursday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD="align: right"]31[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]36[/TD]
[TD="align: right"][/TD]
[TD]Expenses[/TD]
[TD="align: right"][/TD]
[TD]Day of the Month[/TD]
[/TR]
[TR]
[TD="align: center"]37[/TD]
[TD="align: right"][/TD]
[TD]Cell Phone[/TD]
[TD="align: right"]$0[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD="align: right"][/TD]
[TD]KCPL[/TD]
[TD="align: right"]$0[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: center"]39[/TD]
[TD="align: right"][/TD]
[TD]Mortgage/Insurance[/TD]
[TD="align: right"]$0[/TD]
[TD="align: center"]15[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: right"][/TD]
[TD]Car[/TD]
[TD="align: right"]$445[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD="align: right"][/TD]
[TD]Groceries/Gas[/TD]
[TD="align: right"]$150[/TD]
[TD="align: center"]Saturday[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table"]
<tbody>[TR]
[TH="align: center"][/TH]
[TH="align: center"]I[/TH]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="align: right"]$ 445[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table, width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="class: cms_table, width: 100%"]
<tbody>[TR]
[TH="align: center"]Cell[/TH]
[TH="align: center"]Formula[/TH]
[/TR]
[TR]
[TH="align: center"]I27[/TH]
[TD="align: left"]=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")))))))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table"]
<tbody>[TR]
[TH="align: center"][/TH]
[TH="align: center"]H[/TH]
[TH="align: center"]I[/TH]
[TH="align: center"]J[/TH]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD]Car[/TD]
[TD="align: right"]$445[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD]Groceries/Gas[/TD]
[TD="align: right"]$150[/TD]
[TD="align: center"]Saturday[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: cms_table"]
<tbody>[TR]
[TH="align: center"][/TH]
[TH="align: center"]G[/TH]
[TH="align: center"]H[/TH]
[TH="align: center"]I[/TH]
[TH="align: center"]J[/TH]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD]Money Out[/TD]
[TD]Money In[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]1[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]2[/TD]
[TD]Thursday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]3[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]4[/TD]
[TD]Saturday[/TD]
[TD="align: right"]$ 150[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]5[/TD]
[TD]Sunday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]6[/TD]
[TD]Monday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]7[/TD]
[TD]Tuesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]8[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: right"]9[/TD]
[TD]Thursday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: right"]10[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"]11[/TD]
[TD]Saturday[/TD]
[TD="align: right"]$ 150[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]12[/TD]
[TD]Sunday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: right"]13[/TD]
[TD]Monday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: right"]14[/TD]
[TD]Tuesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: right"]15[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: right"]16[/TD]
[TD]Thursday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: right"]17[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: right"]18[/TD]
[TD]Saturday[/TD]
[TD="align: right"]$ 150[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: right"]19[/TD]
[TD]Sunday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: right"]20[/TD]
[TD]Monday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: right"]21[/TD]
[TD]Tuesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: right"]22[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: right"]23[/TD]
[TD]Thursday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: right"]24[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="align: right"]25[/TD]
[TD]Saturday[/TD]
[TD="align: right"]$ 445[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD="align: right"]26[/TD]
[TD]Sunday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="align: right"]27[/TD]
[TD]Monday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: right"]28[/TD]
[TD]Tuesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD="align: right"]29[/TD]
[TD]Wednesday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD="align: right"]30[/TD]
[TD]Thursday[/TD]
[TD="align: right"]$ -[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD="align: right"]31[/TD]
[TD]Friday[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]35[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]36[/TD]
[TD="align: right"][/TD]
[TD]Expenses[/TD]
[TD="align: right"][/TD]
[TD]Day of the Month[/TD]
[/TR]
[TR]
[TD="align: center"]37[/TD]
[TD="align: right"][/TD]
[TD]Cell Phone[/TD]
[TD="align: right"]$0[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD="align: right"][/TD]
[TD]KCPL[/TD]
[TD="align: right"]$0[/TD]
[TD="align: center"]9[/TD]
[/TR]
[TR]
[TD="align: center"]39[/TD]
[TD="align: right"][/TD]
[TD]Mortgage/Insurance[/TD]
[TD="align: right"]$0[/TD]
[TD="align: center"]15[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: right"][/TD]
[TD]Car[/TD]
[TD="align: right"]$445[/TD]
[TD="align: center"]25[/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD="align: right"][/TD]
[TD]Groceries/Gas[/TD]
[TD="align: right"]$150[/TD]
[TD="align: center"]Saturday[/TD]
[/TR]
</tbody>[/TABLE]
2018
[TABLE="class: cms_table"]
<tbody>[TR]
[TH="align: center"][/TH]
[TH="align: center"]I[/TH]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="align: right"]$ 445[/TD]
[/TR]
</tbody>[/TABLE]
2018
[TABLE="class: cms_table, width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="class: cms_table, width: 100%"]
<tbody>[TR]
[TH="align: center"]Cell[/TH]
[TH="align: center"]Formula[/TH]
[/TR]
[TR]
[TH="align: center"]I27[/TH]
[TD="align: left"]=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")))))))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]