View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default another sumproduct question

Off to google!

Ahhhh.



Bob Phillips wrote:

That Lagavulin is good stuff :-))

"Dave Peterson" wrote in message
...
I thought I was seeing things!

Bob Phillips wrote:

Try and say it properly

Most of it was already his, all he had to was to replace
"patch"
with
{"patch","tube"}

:-))

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Bob Phillips" wrote in message
...
Most of it was already his, all he had to was to replace
{"patch","tube"}
with
{"patch","tube"}

:-))


"Dave Peterson" wrote in message
...
In this case, copy the whole formula from Bob's message and paste it
into
the
formula bar for that cell.

(I wouldn't want to type it in from scratch!)

cjjoo wrote:

how do i insert the {} brackets? Do i have to insert them as ctr+
shift
+ enter ?

--
cjjoo


------------------------------------------------------------------------
cjjoo's Profile:
http://www.excelforum.com/member.php...o&userid=26916
View this thread:
http://www.excelforum.com/showthread...hreadid=486158

--

Dave Peterson



--

Dave Peterson


--

Dave Peterson