Count cells with Dates

[helpprod]

i have dates in each cell eg
12/12/01 D1
12/12/01 D2
12/12/01 D3
11/12/01 D4
11/12/01 D4
11/12/01 D4
is there a way to count how many cells have the date 12/12/01 i have a whole month of dates and i need to see what days have the most sales

Thanks
Ryan

 

[PaddyD]

On 2002-10-14 23:34, helpprod wrote:

i have dates in each cell eg
12/12/01 D1
12/12/01 D2
12/12/01 D3
11/12/01 D4
11/12/01 D4
11/12/01 D4
is there a way to count how many cells have the date 12/12/01 i have a whole month of dates and i need to see what days have the most sales

Thanks
Ryan

have you considered using a pivot table for this?

paddy

 

[helpprod]

never used on before!!

 

[PaddyD]

try it (data | pivot table) - you'll be impressed!

 

[The Idea Dude]

Have you considered using

=mode(A1:A19)

where A1:A19 represents the range that contains your sales dates. Remember to format the cell as date or you will just get the number that equals the date.

Any help?

 

[helpprod]

OK what i have is 6 pages with
upto 50 cells on each page eg A1 - A50

A1-A5 has 12/10/02
A6-A10 has 13/10/02
A11-A17 has 14/10/02
A18-A24 has 15/10/02
A25-A50 has 16/10/02

i need a cell that if i type in 12/10/02 another cell tells me there was five sales that day etc.
i dont know where to start or if i can do this so any help would be great!!!!


Ryan

 

[The Idea Dude]

how about this

=SUM(COUNTIF(Sheet1!A1:A50,D1), COUNTIF(Sheet2!A1:A50,D1), COUNTIF(Sheet3!A1:A50,D1), COUNTIF(Sheet4!A1:A50,D1), COUNTIF(Sheet5!A1:A50, D1), COUNTIF(Sheet6!A1:A50, D1))


where D1 is the cell that contains the date you want to find. This may be messy, but it will do the job. Remember to change the sheet names to correspond to yours
This message was edited by The Idea Dude on 2002-10-15 00:59

 

[helpprod]

That worked

Thank you

Ryan