Maybe this

=SUMIF(U1020:BU1020,"*spaar*",U1021:BU1021)

Mike

"Jack Sons" wrote:

Hi all,

I want to do this:

=SUMIF(U1020:BU1020;"*spaar*";U1021:BU1026)

In the cells on row 1020 the word spaar is just part of the entry of the
cell, it is embedded in more text.

I tried

=SUMIF(U1020:BU1020;"*"&"spaar"&"*";U1021:BU1026)
=SUMIF(U1020:BU1020;""*"&"spaar""&"*";U1021:BU1026 )

and more, but all to no avail.

What should it be?

Thanks in advance.

Jack Sons
The Netherlands