I am using an IF logical. If the result is true, I would like to return the
SUM of a range or cells. Or at the very least return cell reference. eg
=IF(K3<=DATE(2010,1,31),AND(K3=DATE(2010,1,1))) Since this is a true
statement, I would like it to return the SUM of A1:A10

Thank you.