Home |
Search |
Today's Posts |
#1
|
|||
|
|||
nesting functions
=SUMIF('N651 DAILY TRIPS'!$A$2:$A$2000,"<="&'BY PAY WEEK'!A2,'N651 DAILY
TRIPS'!$E$2:$E$2000) The above function works, but I need to modify it. Is there a formula where you can use something like =&betweena2&b2? I am trying to modify the above formula to be =to and between 2 different dates, does anyone know a way to do this? I am also trying to do a count function, with the same ranges as above but I do not want to count blanks and I need to add two columns together that meet the same criteria of "<="&'by pay week'!a2. -- Rainy |
#2
|
|||
|
|||
On Tue, 31 May 2005 15:58:01 -0700, "Rainy"
wrote: =SUMIF('N651 DAILY TRIPS'!$A$2:$A$2000,"<="&'BY PAY WEEK'!A2,'N651 DAILY TRIPS'!$E$2:$E$2000) The above function works, but I need to modify it. Is there a formula where you can use something like =&betweena2&b2? I am trying to modify the above formula to be =to and between 2 different dates, does anyone know a way to do this? I am also trying to do a count function, with the same ranges as above but I do not want to count blanks and I need to add two columns together that meet the same criteria of "<="&'by pay week'!a2. In general, to use SUMIF to get events that are between two dates, use a construct of the type: =SUMIF(range,"=" & start_date, sum_range) - SUMIF(range, ""& end_date, sum_range). --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
nesting functions | Excel Worksheet Functions | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
Nesting Functions | Excel Worksheet Functions | |||
What is the syntax for nesting functions such as IF AND? | Excel Worksheet Functions | |||
nesting 18 x functions | Excel Worksheet Functions |