=SUMPRODUCT(--(B1:B10<10), A1:A10)
=SUMPRODUCT(--(B1:B10=10), --(B1:B10<20), A1:A10)
=SUMPRODUCT(--(B1:B10=20), --(B1:B10<30), A1:A10)
=SUMPRODUCT(--(B1:B10=30), --(B1:B10<40), A1:A10)
=SUMPRODUCT(--(B1:B10=40), --(B1:B10<50), A1:A10)
=SUMPRODUCT(--(B1:B10=50), A1:A10)

"Tamsen" wrote:
Hello,
I would like to summarise my dive times (columan A) by depth (column B).
E.g. summed dive times for depths 0-9.9m, 10-19.9m, 20-29.9m, 30-39.9m,
40-49.9m, 50m-.

I cannot find similar syntax in the Function Help section.

Thank you,
Tamsen