COUNTIF
Try
=SUMPRODUCT(--(A1:A100=1),--(B1:B100DATE(2009,1,1)))
It will you the count of dates in Col B greater than 1/1/2009 with 1 in Col
A in the same row...
"observer" wrote:
Trying to count DATA in A:A
Condition is that the DATE that is later than 01-01-2009 in G:G
with this and lots of variations of the following formul:
=COUNTIF('Consolidated Sheet'!$A:$A,'Consolidated Sheet'!$G:$G=("01
January 2009")1)
may be this additional info would enable you to help me.
Ward Date 1 Date 2
1 2008-11-10 2009-11-10
1 2008-11-27 2009-11-27
1 2008-11-28 2009-11-28
1 2008-12-09 2009-12-09
2 2008-12-11 2008-12-11
2 2008-12-23 2008-12-23
3 2008-12-24 2008-12-24
4 2008-12-25 2008-12-25
The task is to count Ward No (1-4) how many times it occurs in the specified
date in Column Date 1 and Date 2
--
Toronto
"Sheeloo" wrote:
Enter the date 1/1/2009 in G1 of 'Consolidated Sheet' and use
=COUNTIF('Consolidated Sheet'!A:A,""&'Consolidated Sheet'!$G$1)
"observer" wrote:
Request for Help
Trying to count DATA in A:A
Condition is that the DATE that is later than 01-01-2009 in G:G
with this and lots of variations of the following formul:
=COUNTIF('Consolidated Sheet'!$A:$A,'Consolidated Sheet'!$G:$G=("01
January 2009")1)
Toronto
|