sumif

[Jack Sons]

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

 

[Don Guillett]

To start, make your ranges match

 

[Mike H]

Maybe this

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

Mike

 

[Jack Sons]

Don,

Oeps, this works: =SUMIF(U1020:BU1020;"*"&"spaar"&"*";U1022:BU1022)
Thank you.

Jack.

 

[Don Guillett]

Glad to help