How to sum values under certain cells that are in the same column?

[Moshpirit]

I have a column with several values and variables; one of these variables is “time”. Under each time variable, there’s a time value; I want to know how to sum these values. I know this is probably not the smartest way of doing this, this is a doubt I have, never found myself in this kind of situation and would like to know how to solve this.

I’m trying with SUMIF and DESREF (like SUMIF(B2:B500; "Time"; DESREF(B2:B500; ROW(B2:B500)+1; 0))), but since there’s so many of them, it’s being very difficult for me.

Here’s an example
ColumnQuestion.ods (20.5 KB)

[EarnestAl]

First, your time intervals should formatted as that, [HH]:MM:SS otherwise they will show unexpected results if the total exceeds 24 hours.

A small modification to your formula
ColumnQuestion105741.ods (17.7 KB)

[karolus]

why not simply:

=SUMIFS(B5:B500;B4:B499;"Time")

??