Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using COUNT for dates and times
There are 3 ocurrences of 'Adams' in A1:A19 and 3 occurrences of '08:00:00'
(in time format) between C1:C19, linked to Adams. There is one occurrence of Adams - 08:15:00:00 between A1:A19 and C1:C19. What function and formula would I use in A20 to return a value of 3 (i.e. to count the Adams at 08:00:00 occurreces)? If I wanted to count Adams (Column A) and (in date format) say, 27/9/06 (in column B), would I use the same formula? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using COUNT for dates and times
Hi,
Give a try to following : =SUMPRODUCT(--(A1:A19)="Adams"*--(C1:C19)="08:00:00") HTH Cheers Carim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using COUNT for dates and times
4 typos and a logic error
=SUMPRODUCT(--(A1:A19="Adams"),--(C1:C19=--"08:00:00")) other part =SUMPRODUCT(--(A1:A19="Adams"),--(B1:B19=--"2006-09-27")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Carim" wrote in message s.com... Hi, Give a try to following : =SUMPRODUCT(--(A1:A19)="Adams"*--(C1:C19)="08:00:00") HTH Cheers Carim |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using COUNT for dates and times
Hi Bob,
Thanks for correcting my mistakes ... I should have been more attentive ... Carim |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using COUNT for dates and times
Bob,
Many thanks for your help - it works perfectly! Tony "Bob Phillips" wrote: 4 typos and a logic error =SUMPRODUCT(--(A1:A19="Adams"),--(C1:C19=--"08:00:00")) other part =SUMPRODUCT(--(A1:A19="Adams"),--(B1:B19=--"2006-09-27")) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Carim" wrote in message s.com... Hi, Give a try to following : =SUMPRODUCT(--(A1:A19)="Adams"*--(C1:C19)="08:00:00") HTH Cheers Carim |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using COUNT for dates and times
Carim,
Many thanks for your help! Tony "Carim" wrote: Hi Bob, Thanks for correcting my mistakes ... I should have been more attentive ... Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
Count times between 2 times and 2 dates | Excel Programming | |||
Count No. of times Dates are repeated | Excel Discussion (Misc queries) | |||
Times and Dates | Excel Discussion (Misc queries) |