Thread
:
sumif
View Single Post
#
4
Posted to microsoft.public.excel.misc
Jack Sons
external usenet poster
Posts: 144
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
Reply With Quote
Jack Sons
View Public Profile
Find all posts by Jack Sons