Is there a way to make a single cell do the following?

1. Within "Sheet 1", is it possible to display the actual numreical value
of a total sum value of a certain data set within the same cell as a if it
were a button? For example, the cell "D15" will display "400" as a grand
total of subset data and the cell would have a button like effect such as a
command button works.

2. Also, from within that same cell, when the cell area (command button?)
is clicked it creates a pop-up of the data source with the full data set
displayed?