I am having a problem writing a formula to calculate the information I
need in report. Is it possible to write a formula that will
automatically fill in the pink table based on the information contained
in the 3 columns? I manually plugged the numbers in the pink cells but
am wondering if there is a way to automate this.

Thank you for any help.

Steve


+-------------------------------------------------------------------+
|Filename: Formula.pdf |
|Download: http://www.excelforum.com/attachment.php?postid=4737 |
+-------------------------------------------------------------------+

--
hipkey
------------------------------------------------------------------------
hipkey's Profile: http://www.excelforum.com/member.php...o&userid=34245
View this thread: http://www.excelforum.com/showthread...hreadid=539962