LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 102
Default How to weave in Date Information please?

The Formula below works, however I'm having difficulty integrating "date"
parameters into them.

In Column A of the Raw Data spreadsheet I have "Discharge Dates". I want the
two formulas below to work on all data inpuut between July 1, 2009 and up
until Sept 30, 2009. Any data input before or after the date parameters
identified would not register in the calculations. Could someone assist me in
incorporating the appropriate "date" parameters into the formulas below.
Thank you! Dan

=IF(COUNTIF('Raw Data'!$H$4:$H$5000,"Barb B"),AVERAGE(IF('Raw
Data'!$H$4:$H$5000="Barb B",'Raw Data'!$C$4:$C$5000)),"")


=IF(COUNTIF('Raw Data'!$F$4:$F$5000,"OP"),AVERAGE(IF('Raw
Data'!$F$4:$F$5000="OP",'Raw Data'!$C$4:$C$5000)),"")
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I weave in "date" information to my formulas? Danny Boy Excel Worksheet Functions 2 July 5th 09 07:14 AM
Only show information after a certain date Dom Excel Discussion (Misc queries) 1 April 25th 08 12:00 PM
Pulling information from another wksheet by date tonysalas Excel Discussion (Misc queries) 1 July 20th 06 05:06 AM
Help - Information with time and date PM Excel Discussion (Misc queries) 4 January 6th 05 08:25 AM
How can I sum information in a list with a date range? Dave Excel Worksheet Functions 2 November 23rd 04 08:17 PM


All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"