View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Morrigan
 
Posts: n/a
Default Problem with a SUMPRODUCT Formula


Hmm.....that's it. If that didn't fix it, it's probably not due to the
misinterpretation of copy and paste from other sources.


carl Wrote:
And then what ? What am I looking for ?

"Morrigan" wrote:


carl Wrote:
Thank you. Not sure what you are refering to. can you please

elaborate
?

"Morrigan" wrote:


I am guessing this is one of those instants where Test to

Columns
may
help. Apply Data - Test to columns - Finish to the 2 columns
Summary!C and AMS!B.


--
Morrigan


------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=524394





Highlight the 2 columns, go to Data - Text to columns - click

Finish


--
Morrigan

------------------------------------------------------------------------
Morrigan's Profile:

http://www.excelforum.com/member.php...fo&userid=7094
View this thread:

http://www.excelforum.com/showthread...hreadid=524394




--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=524394