Summing unique value using daytime as criteria

[Luc_69]

Hi All - I need to know how to sum unique values and use the date as a criteria or filter. For example

Ive been trying something like productsum(1/countif(value_range,value_range),value_range) but thats as far as I get ??

Any ideas ??

 

[Luc_69]

You just have to do CSE in the first formula.
Then you can copy or drag the formula.

Yes - thanks that worked. I had to f9 as well