| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count in a range of dates?
I have column A with dates, Colum B with $. I want to sum a dollar amount,
only if it falles within the date range. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count in a range of dates?
=sumif(a:a,"="&date(2005,1,1),b:b)-sumif(a:a,"="&date(2005,2,1),b:b) should
give you the total for Jan '05. Change the date ranges to suit your needs. "nancy" wrote: I have column A with dates, Colum B with $. I want to sum a dollar amount, only if it falles within the date range. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I count in a range of dates?
=SUMPRODUCT(--(A2:A200=--"2005-11-01"),--(A2:A200<=--"2005-11-30"),B2:B200)
you could put the dates in cells and test those cells -- HTH RP (remove nothere from the email address if mailing direct) "nancy" wrote in message ... I have column A with dates, Colum B with $. I want to sum a dollar amount, only if it falles within the date range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Character Count Range of Cells | Excel Discussion (Misc queries) | |||
| Count cells based on date range in another column | New Users to Excel | |||
| Find (Today-21) in a range of dates | Excel Discussion (Misc queries) | |||
| Sum between a range of dates | Excel Worksheet Functions | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Linear Mode
