In order to see the cells associated with the SUM function pull down Tools
Auditing Trace Precedents
--
Gary's Student


"minrufeng" wrote:


Do someone know how to complete this function in excel?

The value of one cell is the sum of values of other cells. When I click
the sum cell, rows including those related cells will be highlighted.


--
minrufeng
------------------------------------------------------------------------
minrufeng's Profile: http://www.excelforum.com/member.php...o&userid=26208
View this thread: http://www.excelforum.com/showthread...hreadid=395135