View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harsha Harsha is offline
external usenet poster
 
Posts: 1
Default 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.