Count values in rows depending on dates.

G

Guest

In cell A1:A20 I have dates and in cell B1:B20 I have categories (ex a, b,
c). I'd like to count the number of times A is present within the last 6
months from todays date. I'd also like to count the total number of actual
entries in range B1:B20.

Thanks for any help.
 
G

Guest

=SUMPRODUCT(--(A1:A20>DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))),--(B1:B20="a"))


=COUNTA(B1:B20)


Regards,

Peo Sjoblom
 

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

formulas to count dates 2
Excel Formula - Count Dates from another Sheet 8
Conditionally summing data from two columns depending on their value. 3
If & sumproduct formula with text 3
want to count in two columns; countif (colA=x AND colB=y)? 1
Moving Average 8
COUNT rows on external sheet if between date range 3
Counting depending on another column 4

Top