Help with Dates in a Formula
Try this im assuming that there is no data for 2007
9 is for the month of Sept
=SUMPRODUCT((MONTH($A$12:$A$399)=9)*($B$12:$B$399= "PI")*($E$12:$E$399))
"Jerry Rogers" wrote:
Hi,
I need to change the reference (=B474) in this formula to something that
will select all entries in the range A12:A399 that fall within the month of
SEP 06 then sum the numbers found in Column E. The cells in range A12:A39
are formatted as dates. I don't know how to enter this. Please help.
=SUMPRODUCT(($B$12:$B$399="PI")*($A$12:$A$399=B474 )*($E$12:$E$399))
Thanks
--
Jerry
|