Thanks for that. Actually my starting cell would be G2 and I amusing a function not a formula (sorry, got the terminology wrong!)Function is =SUMIF(C:C,F2,D:D) and is to be copied down as far asthere is contiguous data in column F.