View Full Version : Need excel help
Blitzkrieg
7/11/2006, 03:36 PM
I have a range of 980 dates, they are actually real estate closing dates. I want to count the number as they occur each month, by month. In other words, how many closed in Jan, Feb, etc.
Do I use a pivot table?
Hamhock
7/11/2006, 03:39 PM
i'd just chop them into 12 lists, then use COUNT
but, I'm lazy like that
skycat
7/11/2006, 03:43 PM
Write a VBA script.
YWIA
Blitzkrieg
7/11/2006, 03:51 PM
speak english, please.
mdklatt
7/11/2006, 04:00 PM
I have a range of 980 dates, they are actually real estate closing dates. I want to count the number as they occur each month, by month. In other words, how many closed in Jan, Feb, etc.
Do I use a pivot table?
COUNTIF(), or a slick combination of IF() and SUM()--ask the paperclip for examples.
My excel skills are pretty basic, but I would add a column to the side and use =month(cell reference). Then =countif()
jkm, the stolen pifwafwi
7/11/2006, 04:15 PM
countif(month(cell), 1)
countif(month(cell),2)
countif(month(cell),3)
etc...
Blitzkrieg
7/24/2006, 12:43 PM
So if my dates are represented as number i.e. 1/05/2005, how then do I do this?
mdklatt
7/24/2006, 12:47 PM
So if my dates are represented as number i.e. 1/05/2005, how then do I do this?
Try this:
=countif(month(datevalue(A1)), 1)
etc.
Powered by vBulletin® Version 4.2.1 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.