My worksheet has a column containing the amounts of checks received for deposit in the bank, and a column containing the dates the checks were deposited. If a check has been deposited, its amount is in the amounts column and there is a date in the corresponding dates column. If a check has been received but not yet deposited, its amount is in the amounts column, but its dates column is blank.
My objective is to calculate the sum of the amounts for checks that have actually been deposited.
Range F10:F99, named ChecksReceived, contains blanks or the amounts of the checks received. Range I10:I99, named DatesOfDeposts, contains blanks or the dates of the deposits.
I've tried various forms of the SUMIF function, but nothing has worked. Descriptions of SUMIF are pretty sketch, IMHO, but I'm thinking that SUMIF isn't the solution to my need.