using a formula to compare dates

[george]

I would like to create a formula that would count the amount of rows that
have today's date. For example:

Today's date: 10/02/2004

Who Date Serial # Pass
GGG 10/2/2004 12121 1
GGG 10/2/2004 12121 1
GGG 10/2/2004 12121 1
GGG 10/2/2004 12121 1
GGG 10/2/2004 12121 1


I want to compare the "date" column to the current date and sum up the
numbers in the "Pass" column. In this case the formula result would be "5".
I'm thinking it's a combination of VLOOKUP and the SUM function. Any help
on this would be greatly appreciated.

 

[Ashish Mathur]

Hi,

Use the sumif function. The formula will be:

SUMIF(C68,C4,D68)

C68 - The entire range
C4 - the date which you are looking for
D68 - The pass column range


Regards,

Ashish Mathur

 

[george]

Works great! Thanks for the quick response.

Hi,

Use the sumif function. The formula will be:

SUMIF(C68,C4,D68)

C68 - The entire range
C4 - the date which you are looking for
D68 - The pass column range


Regards,

Ashish Mathur

 

[Domenic]

=SUMIF(B2:B6,"10/02/2004",D26)

=SUMIF(B2:B6,DATE(2004,10,2),D26)

=SUMIF(B2:B6,TODAY(),D26)

Hope this helps!