Hi and welcome

Are you saying each cell in B2:B31 is 3 or the total of those cells is 3? Is B32 just the sum of the above?

Might be easier to provide a solution if you could attach a sample workbook and let us know what the desired result is.

BSB