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 |
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 |
All times are GMT +1. The time now is 12:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com