Ok in Cell B4:B23 I have dates of the month and Cells C4:C23 I have the amounts due for a bill. I would like to have a 2 formulas one for the 1st thru 15th and then the 16th thru 31st and add up the amounts due on the 1st half of the month and then the second half