Countif & Month
use ctrl + shift + enter once u enter the formula
On Oct 10, 7:50*pm, muddan madhu wrote:
try this
for choice A
=COUNT(IF($A$2:$A$6="X",IF(MONTH($C$2:$C$6)=row(1: 1),)))
and drag it down
for choice B
=COUNT(IF($B$2:$B$46="X",IF(MONTH($C$2:$C$6)=ROW(1 :1),)))
and drag it down
On Oct 10, 7:11*pm, Bigfoot17
wrote:
* * *A * * * * * * * B * * * * * C
ChoiceA * * ChoiceB * * Exp.Date
* * *X * * * * * * * * * * * * *11/2/08
* * *X * * * * * * * * * * * * *12/4/08
* * * * * * * * * * * *X * * * *3/15/09
* * * * * * * * * * * *X * * * *5/17/09
* * *X * * * * * * * * * * * * *2/28/09
* * * * * * * * * * * *X * * * *10/10/08
I have something similar to the above except with 2500 rows. *I am looking
to have on a second sheet a count of the number of ChoiceAs and the number of
ChoiceBs that expire for each month of the year.
* * * * * ChoiceA * * ChoiceB
Jan
Feb
Mar
April
...
(To complicate matters I have a spinner for the year so you can change the
2008 to 2009 and see the expirations in 2009).- Hide quoted text -
- Show quoted text -
|