counting entries in a range of data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am working on counting dates within a range. I am trying the countif formula but have been trying the count formula also adding the -- to make it return 1's or 2's ? Well I am stumbling and hope I can get help?

Thanks,

Todd

E
01/01/04
05/04/04
01/01/04

=COUNTIF($E$3:$E$36500,MONTH($E3:$E$36500)=1)
 
Hi,

Try doing a Google search for SUMPRODUCT or multi-conditional count.
An example...

=SUMPRODUCT(--(MONTH($E3:$E$36500)=1))

Which is actually going to make a huge array. Or you could use a
array formula...

=COUNT(IF(MONTH($E3:$E$36500)=1,$E3:$E$36500))

Confirmed with Ctrl + Shift + Enter. Caveat: it doesn't handle blan
cells very well, in fact not at all, and will give you erroneou
results. I'd suggest the SUMPRODUCT with another variation t
disregard the blanks altogether...

=SUMPRODUCT(--(MONTH($E3:$E$36500)=1),--($E3:$E$36500<>""))

Remeber, with SUMPRODUCT, the ranges must be of equal size
 
Back
Top