counting the number of dates

  • Thread starter Thread starter GORDON
  • Start date Start date
G

GORDON

I was using the tip counting the number of times dates in certain month
appears. I also needed it to count the number of "E"'s for that
month. the array that I used was:
=sum((month(a2:a11)=b2)*(year(a2:a11)=c2*1) column d would have some
blanks and some E'S. Would it be better off to use if,and,or
statements than the array or would I just and the if statements at the
end of the array?
 
=SUM((MONTH(A2:A11)=B2)*(YEAR(A2:A11)=C2)*ISNUMBER(A2:A11))

to be confirmed with control+shift+enter instead of just with enter.

=SUMPRODUCT(--(MONTH(A2:A11)=B2),--(YEAR(A2:A11)=C2),--ISNUMBER(A2:A11))

does not require control+shift+enter.
 
Another issue I was having was to count the number of dates that wa
less than or equal to todays date and must have the letter E in anothe
column.

That is coulmn A would have the date 2003-10-21 column B would have th
letter E and column C would have the formul
=countif(A:A<="today")*(b:b,="E")

This seems logical but still lacks something for it to be correct.

I would appreciate any help anyone can give me with my two problems.
Thank
 
You must log in or register to reply here.

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

Counting the Number of Elements in an Array 3
Excel - in a row of numbers, put last entered number Cell B2 7
Excel Dates advice please 4
Compare an Array to a Date Range 9
Offset Formula 3
Formatting Dates from Text to Numbers 2
Counting cells with particular month and year 2
Counting dates with conditions 2

Back
Top