Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing occurances of text by fiscal month
I have a sheet with a column with a date(date format) and a column of
type(text). I'm trying to figure out how to count the number of times something appears in the type column for a specific date range(financial month). I'm currently using =COUNTIF('DAILY PI'!U:U,"various text entry") for my yearly count, but I need to set up lookups based on financial month. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=month() function equivalent for fiscal calendar | Excel Worksheet Functions | |||
Defining fiscal month for pivot table | Excel Discussion (Misc queries) | |||
Summing up of data for this month | Excel Discussion (Misc queries) | |||
Summing Values In Current Month Only | Excel Worksheet Functions | |||
Count the occurances of a month in a range of date fields | Excel Worksheet Functions |