Hi Milo,

Am Sun, 7 Apr 2013 10:18:34 +0000 schrieb Milo Bloom:

Thanks for the help but the problem with that is not all columns end at
row 32, they end between rows 29 and 32. Row 33 and below (i did not
include that) start doing a bunch of number crunching for the specific
month.

you can use the greatest range e.g. C2:C32
Empty cells will be ignored


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2