View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default another sumproduct question

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