Hi Colin
Thanks for the reply.

So you can add all the formula directly into the top "Range" box in the "sumif" dialogue box,no need to use "criteria" and "sum Range". or directly to fomulae bar

much appreciated