I am trying to automate a checkbook function for my home (I track finances in Excel). I simply want to be able to verify (on the "JUN" tab)- for any row, that a value exists in column D (the amount of a check), Column G (check number), and a textual character in column H (I use "Y", "y", "X", "x" as valid criteria to mark the 'check' cleared).
After validating if a check is cleared or not, I wish to take check values which have NOT cleared and sum them up on the second tab. On the tab of my workbook "June subtotals". I have a lengthy IF statement:
=IF(AND(JUN!$D2<>"",AND(JUN!$G2<>"",OR(JUN!$H2="Y",JUN!$H2="y",JUN!$H2="X",JUN!$H2="x"))),"",JUN!$D2)
It is currently returning information even when I have nothing in Column G ("Check #"). Any chance someone could help?
Currently, I use conditional formatting on the "JUN" tab to turn the cell green for a cleared check, if one of the specific values is input in that column.
Bookmarks