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


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