If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I check if a date falls between a range then sum other # if tr
|
#2
|
|||
|
|||
=SUMPRODUCT(--(A2:A20=--"2005-10-01"),--(A2:A20=--"2005-10-31"),B2:B20)
-- HTH Bob Phillips "clovins1" wrote in message ... |
#3
|
|||
|
|||
Since you ask in general terms, I guess an answer in general terms
is okay. Yes. Suppose you have a low date in column A and a higher date in Column B and you want to know if the date in C falls on or between those dates. =IF(AND(A1=C1,B1=C1), SUM(D1:F1),0) Please include all parts of a question in the body, as you can see your question as incomplete as it was, was also truncated. Because you are so hung up on trying to keep the question small enough to fit in the subject it is indeterminate if you meean SUM or Some and if you mean number or numbers like in a range.. I have a feeling that Bob Phillips understood your question and gave you the answer you want, but I think it is subject to interpretation. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "clovins1" wrote in message ... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
HELP - Date Range In 1 Cell Calculation | Adam | Worksheet Functions | 6 | September 19th, 2005 08:24 PM |
querie Criteria date range and find records on ProductType | Rodrigo R via AccessMonster.com | Running & Setting Up Queries | 1 | August 5th, 2005 11:26 PM |
How do I query for a date range? | Kingster | General Discussion | 6 | April 20th, 2005 06:07 PM |
Date Range Code Needed! (Thanks) | Dave Elliott | Using Forms | 1 | March 7th, 2005 03:29 PM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |