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