If you really have the date in column C:
=SUM((MONTH(C13:C165)=3)*(L13:L165="Won")*(J13:J16 5))
(array entered, still)
And those ranges have to be the same size (I changed L13:L196 to L13:L165).
This formula is equivalent, but it's not array entered:
=SUMPRODUCT(--(MONTH(C13:C165)=3),--(L13:L165="Won"),(J13:J165))
The double minuses convert trues/falses to +1/0's.
And =sumproduct() likes to work with numbers--not logical values.
Mark wrote:
Hello,
Is it possible to sum up all contracts won in a given
month? This is the information I enter into excel.
Kit#, Submit Date, Award Date, # of Kits, Price Quoted,
Won / Lost. The date format is 4-Mar-97. I only want to
sum the awards that have Won in the Won / Lost Colomn.
Here is the formula I used.{=SUM((C13:C165="Mar")*
(L13:L196="Won")*(J13:J165))}. Thanks in advance for
your help.
Mark
--
Dave Peterson
|