Finding consecutive numbers or dates

I'd like to find out if Excel can locate consecutive numbers.

For example: Column A has days of the month entered (1-31), but not necessarily every day of the month. I'd like Excel to find consecutive numbers in adjacent cells within the column; i.e., A4 has a "6" entered and A5 has a "7", and if found, sum the values in the adjacent cells in Column B.

Then, assuming there may be more than one pair of consecutive numbers in Column A, I'd like Excel to determine which pair of consecutive numbers have the highest corresponding values in the adjacent B Column.

Can this be done?

Hi

With your numbers, starting in A1, then in B2, try this.

=IF(A2=A1+1,A1+A2,"")

Is this what are you looking for?

Copy(drag down) the formula..

You are welcome!