Re: Count certain months
- From: "John Michl" <waxwing1@xxxxxxxxx>
- Date: 4 Jan 2006 10:54:22 -0800
Try the following array formula:
=SUM(IF(MONTH(A1:A5)=12,1,0)) commit it by hitting Ctrl-Shift-Enter
- John
www.JohnMichl.com
.
- Prev by Date: Re: Output in Column A based on Input in Column B
- Next by Date: Re: Output in Column A based on Input in Column B
- Previous by thread: Re: sum up the ROW values with ref to COLUMN values!
- Next by thread: Re: Count certain months
- Index(es):
