count column c with condition in column A
 

Hi,

I have an excel sheet like the one below. Now I want to count number
of images in day basis. That is how many on 1-feb-08, how many on 2-
feb-08,
Date Shift Image No. HC Manip Min Worked
1-Feb-08 III 28135 1 0 15.00
1-Feb-08 III 28169 1 0 15.00
2-Feb-08 III 0 0 15.00
2-Feb-08 III 28197 1 0 15.00
2-Feb-08 III 28244 1 0 15.00
3-Feb-08 III 28267 1 0 15.00
3-Feb-08 III 28270 0 1 15.00
4-Feb-08 III 28271 1 0 15.00

Can someone please help me with this.

count column c with condition in column A
 

=COUNTIF(A:A,--"2008-02-01")

or if the date is in a cell say M1

=COUNTIF(A:A,M1)


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Harsha" wrote in message
...
Hi,

I have an excel sheet like the one below. Now I want to count number
of images in day basis. That is how many on 1-feb-08, how many on 2-
feb-08,
Date Shift Image No. HC Manip Min Worked
1-Feb-08 III 28135 1 0 15.00
1-Feb-08 III 28169 1 0 15.00
2-Feb-08 III 0 0 15.00
2-Feb-08 III 28197 1 0 15.00
2-Feb-08 III 28244 1 0 15.00
3-Feb-08 III 28267 1 0 15.00
3-Feb-08 III 28270 0 1 15.00
4-Feb-08 III 28271 1 0 15.00

Can someone please help me with this.