View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
robert111
 
Posts: n/a
Default How do I get a pivot table to ignore some values


use the sumproduct function


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=534499