Thread: Help with Dates in a Formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Help with Dates in a Formula
One way

Try:
=SUMPRODUCT(($B$12:$B$399="PI")*(TEXT($A$12:$A$399 ,"mmmyy")="Sep06")*($E$12:$E$399))

Above assumes real dates within A12:A399
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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
Reply With QuoteReply With Quote