sumif
 

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

sumif
 

To start, make your ranges match

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack Sons" wrote in message
...
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

sumif
 

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

sumif
 

Don,

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

Jack.

"Don Guillett" schreef in bericht
...
To start, make your ranges match

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack Sons" wrote in message
...
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

sumif
 

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack Sons" wrote in message
...
Don,

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

Jack.

"Don Guillett" schreef in bericht
...
To start, make your ranges match

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jack Sons" wrote in message
...
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