Some help please. upon the running of a macro I would like to be able to
display in a message box the sum of numbers in the seven cells above the
active cell and also the average of the sum of the same cells that contain a
number greater than zero.

TIA

Neal