Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Count IF 's
Hi Guyz,
Was just wondering whats the best way to do the following: If got with lots of columns. Two of those columns are "Date" and "Time". Then i have a section that i want to Count the dates. Like this: 2007/03/01 2007/03/02 2007/03/03 Count 2 1 2 (The dates are the headings btw) Anyway, so i got that to work fine but want to go one step further: I want it to look like this: 2007/03/01 2007/03/02 2007/03/03 08:00 2 1 2 09:00 3 5 1 10:00 5 2 2 11:00 1 1 2 So my question is: How do i do a Count that is equal to a date and a time. Fanks guyz! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Count IF 's
My dates and times are in columns G & H:
Put in B2 of the results table abd copy aroos and down =SUMPRODUCT(--($G$2:$G$26=B$1),--(HOUR($H$2:$H$26)=HOUR($A2))) Results table: A B C D 01/03/2007 02/03/2007 03/03/2007 ' <== row 1 08:00 0 0 1 09:00 2 1 0 HTH "ant1983" wrote: Hi Guyz, Was just wondering whats the best way to do the following: If got with lots of columns. Two of those columns are "Date" and "Time". Then i have a section that i want to Count the dates. Like this: 2007/03/01 2007/03/02 2007/03/03 Count 2 1 2 (The dates are the headings btw) Anyway, so i got that to work fine but want to go one step further: I want it to look like this: 2007/03/01 2007/03/02 2007/03/03 08:00 2 1 2 09:00 3 5 1 10:00 5 2 2 11:00 1 1 2 So my question is: How do i do a Count that is equal to a date and a time. Fanks guyz! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count on multiple parameters | Excel Worksheet Functions | |||
how do I count with multiple arguments | Excel Worksheet Functions | |||
COUNT or SUM with multiple criteria | Excel Worksheet Functions | |||
Count on multiple columns | Excel Worksheet Functions | |||
Count with multiple conditions | Excel Worksheet Functions |