Have a table want to sum the values in one column if the corrosponding value in an adjcent column is not blank. So, Column B has a lest of deposits, Column D has check if the deposit is cleared. I want to sum all of the values in B that are not checked.
=SUMIF([Cleared]," ",[Payment]) doesn't work