On 18 Oct, 13:22, Pete_UK wrote:
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- Hide quoted text -

- Show quoted text -


No problem really,
It's just that the spreadsheet has so much content that requires an
input, that we are now reviewing all areas where the input could be
either automated or simplified.

So the less input required the better.

Thanks again,

Mike