| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I weave in "date" information to my formulas?
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert numbers to date: "586" to read "May 1986" | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
Threaded Mode
