Spreadsheet Formulas

css navigation by Css3Menu.com

Count Number by Month

Array formula where we count the number of cells where a date is in a particular month.

Remember To tell Excel that your formula is an array, hold the Ctrl & Shift keys while pressing Enter. Brackets {} will be displayed around it.

{=SUM(IF(LEFT(TEXT(B3:B14,"mmddyy"),2)="12",1,0))}

Starting from the middle, take the dates in B3 through B14 and convert to text in the format mmddyy. Grab the left 2 characters (mm) and look for 12. If found add 1, if not add zero.

© 2000-2016

Updated:  11/16/2016 19:50
This page added:  06 April 2000