Try

=SUMPRODUCT(--(C1:C1000="08:15"),F1:F1000)


"Zakynthos" wrote:

I want to add all values in column F, (a+b+c etc, below) corresponding to a
description in column C of "08:15" and to ensure that any value corresponding
to ANY TIME OTHER THAN 08:15 was NOT INCLUDED in the total

Example:

C1 contains the time "08:15"
F1 contains the value to be added, which I will call "a"
C365 contains the time "08:15"
F365 contains the second value to be added which I will call "b"
C729 contains the time "08:15"
F729 contains the third value to be added which I will call "c" , etc etc

Two questions, then:

1. What formula could I input to achieve the above, i.e. to get the sum of
a+b+c ?

2. I also want to ensure that if one of the cells in column C showed a time
other than 08:15 that the value in the corresponding column F was NOT added,
so for example if C729 above had "08:30" instead of "08:15", I would not want
value "c" above included in my total.

Many thanks for your help !!!!