View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jdame95 jdame95 is offline
external usenet poster
 
Posts: 1
Default 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?