About Us

Don Guillett

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"	Harry Seymour	Excel Worksheet Functions	9	June 12th 07 10:47 PM
Embedding a Sumif in a sumif	C.Pflugrath	Excel Worksheet Functions	5	August 31st 05 07:31 PM
Sumif help	Hirsch	Excel Worksheet Functions	1	June 16th 05 10:18 PM
nested sumif or sumif with two criteria	dshigley	Excel Worksheet Functions	5	April 5th 05 03:34 AM
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function	Oscar	Excel Worksheet Functions	2	January 11th 05 11:01 PM