I can't think of a way - SUMIF relies on matching data from the range
in its first parameter to the contents of its second parameter, so if
you had blanks in column A it would not be able to match with it.

Is there a problem recording the receipt number on every row?

Pete

On Oct 18, 1:04 pm, Mik wrote:

Thanks for your responce Pete,

Is there a way of applying this without having to insert the receipt
number for all transactions?

Mike