The formulas given do work but you have a second option...
Choose...Tools, Addins and turn on your conditional sum wizard...Then
from the Tools menu choose 'conditional sum' and add whatever
conditions you want to the grid as shown in the graphic i
uploaded...last steps just ask you where you want your answer/s to
land...choose however many cells you need to catch the final result.
Luck to you
NMP
+-------------------------------------------------------------------+
|Filename: CSumWizard Example.JPG |
|Download:
http://www.excelforum.com/attachment.php?postid=3586 |
+-------------------------------------------------------------------+
--
Padgett
Master Certified Office Applications Instructor
------------------------------------------------------------------------
Padgett's Profile:
http://www.excelforum.com/member.php...fo&userid=5670
View this thread:
http://www.excelforum.com/showthread...hreadid=385838