Discussion
Afternoon all.
i have a ratehr large spreadsheet that tracks how many messages were sent from a client on a month to month bass. I have a seperate sheet for each month and in those sheets i want to know how many messages were sent by day.
I have a column in there for date in dd/mm/yyyy format and i can use =COUNTIF(RANGE,CRITERIA) but it's a pain in the hole doing it seperately for each day.
Is there a way that i can search an entire colums for each date (01/10/2009 - 31/10/2009 for example) and spit out the total number of times it finds a each date?
So say i had a record of 20 messages for the 1st and 40 for the second and so on, can it be smart enough to know when to change?
I know someone os going to say macro - but i'm not that savvy.
Cheers,
D.
i have a ratehr large spreadsheet that tracks how many messages were sent from a client on a month to month bass. I have a seperate sheet for each month and in those sheets i want to know how many messages were sent by day.
I have a column in there for date in dd/mm/yyyy format and i can use =COUNTIF(RANGE,CRITERIA) but it's a pain in the hole doing it seperately for each day.
Is there a way that i can search an entire colums for each date (01/10/2009 - 31/10/2009 for example) and spit out the total number of times it finds a each date?
So say i had a record of 20 messages for the 1st and 40 for the second and so on, can it be smart enough to know when to change?
I know someone os going to say macro - but i'm not that savvy.
Cheers,
D.
Landlord said:
If I've understood you correctly;
Have a sheet with a column of the dates you want;
etc.
Oops - didn't read Mattt's answer earlier which is the same thing!
That's how I'd have done it too. Nice and simpleHave a sheet with a column of the dates you want;
A | B | |
1 | 1/10/2009 | =COUNTIF(RANGE, A1) |
2 | 2/10/2009 | =COUNTIF(RANGE, A2) |
etc.
Oops - didn't read Mattt's answer earlier which is the same thing!
Edited by Landlord on Wednesday 7th October 15:30
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff