Posted to microsoft.public.excel.worksheet.functions

Jerry Rogers Jerry Rogers is offline

external usenet poster

Posts: 8

Help with Dates in a Formula

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula With Dates	Mike	Excel Worksheet Functions	1	January 31st 06 03:13 AM
Formula for dates	shunt	Excel Discussion (Misc queries)	2	January 24th 06 11:15 PM
how do I use if formula using dates?	Simone	Excel Worksheet Functions	4	November 8th 05 02:40 AM
formula for dates	pascot	Excel Discussion (Misc queries)	1	June 21st 05 08:33 AM
dates formula	Jerry Kinder	Excel Worksheet Functions	6	May 18th 05 08:34 PM

All times are GMT +1. The time now is 06:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us