summing occurances of text by fiscal month

  • Thread starter Thread starter jdame95
  • Start date Start date
J

jdame95

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?
 
Assuming real dates in col A

If it's for a certain mth/yr, something like this:
=SUMPRODUCT((TEXT('Daily PI'!A1:A100,"mmmyy")= "Jan08")*('Daily
PI'!U1:U100="Text1"))

If it's for a certain period (startdate to enddate),
then something like this:
=SUMPRODUCT(('Daily PI'!A1:A100>= --"15 Jan 2008")*('Daily PI'!A1:A100<=
--"14 Feb 2008")*('Daily PI'!U1:U100="Text1"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:55
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fiscal Month Formula 3
Conditional Formatting an Entire document 1
Date range help 2
Count the Number of Weekdays by Month 3
Sum by variable column 1
using fiscal year calculations in a formula 1
sum and count text and numbers same column 1
Pivot Table - Finanical information by Period as a month 1

Back
Top