Thread
:
sumif
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett