need help please

W

Wayne

I wish to count the entries in a column (G) of dates that fall within a calendar quarter ie 04/01/03 and 06/30/03
I tried many formulas such as this one (none work) =COUNTIFand(G14:G238,"=>04/01/03,=<06/30/03") which returns
"#NAME?" some I've tried returned zero. Can anyone help with this? Thanks.
 
J

JE McGimpsey

One way:

=SUMPRODUCT(--(G14:G238>=DATE(2003,4,1)),--(G14:G238<=DATE(2003,6,30)))

Another:

=COUNTIF(G14:G238,">=4/1/2003") - COUNTIF(G14:G238,">6/30/2003")
 
M

Michael J. Malinsky

Have you tried:

=COUNT(G14:G238)

or

=COUNTA(G14:G238)

The difference is that COUNT counts numbers. So if your dates are not in
text format, it should work. COUNTA counts all cells in the range. Both
ignore empty cells.

HTH
Mike.

--
Michael J. Malinsky


Wayne said:
I wish to count the entries in a column (G) of dates that fall within a
Click to expand...
calendar quarter ie 04/01/03 and 06/30/03.
I tried many formulas such as this one (none work)
Click to expand...
=COUNTIFand(G14:G238,"=>04/01/03,=<06/30/03") which returns
 
Top