Re: Percentage of the occurance of a word in a date range
- From: Art-SNL <ArtSNL@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 5 May 2008 22:21:00 -0700
Valko,
Thanks for the reply. I'm still having trouble (probably because I don't
have a good grasp of arrays). I tweaked it a little because I am referencing
a different worksheet named "Life Cycle". My data starts at row 10 and I
need to caluclate all future entries, so I adjusted the range. However my
data currently only has 150 rows. Any additional tips? Jeez, I'm dumb!
=SUMPRODUCT(--(MONTH('Life Cycle'!A10:A900)=1),--('Life
Cycle'!M10:M900="Res"))/SUMPRODUCT(--(MONTH('Life
Cycle'!A10:A900)=1),--('Life Cycle'!M10:M900<>""))
"T. Valko" wrote:
Assuming there are no empty cells in the date range (empty cells will.
evaluate as month January).
=SUMPRODUCT(--(MONTH(A1:A20)=1),--(M1:M20="res"))/SUMPRODUCT(--(MONTH(A1:A20)=1),--(M1:M20<>""))
Format as PERCENTAGE
--
Biff
Microsoft Excel MVP
"Art-SNL" <Art-SNL@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6EC218C3-A9A7-46AB-9DA2-D002E0290275@xxxxxxxxxxxxxxxx
I have a spreadsheet with dates in Column A, and either the word "Res" or
"Comm" in Column M. How can I find out the percentage of "Res" for all
the
records in January?
PS - there is an abundance of extreme talent in this community! Thanks
for
all your postings!
- Follow-Ups:
- Re: Percentage of the occurance of a word in a date range
- From: T. Valko
- Re: Percentage of the occurance of a word in a date range
- From: Art-SNL
- Re: Percentage of the occurance of a word in a date range
- References:
- Percentage of the occurance of a word in a date range
- From: Art-SNL
- Re: Percentage of the occurance of a word in a date range
- From: T. Valko
- Percentage of the occurance of a word in a date range
- Prev by Date: Re: Percentage of the occurance of a word in a date range
- Next by Date: Re: Percentage of the occurance of a word in a date range
- Previous by thread: Re: Percentage of the occurance of a word in a date range
- Next by thread: Re: Percentage of the occurance of a word in a date range
- Index(es):
Relevant Pages
|
