How to sum every N rows

preview_player
Показать описание
Adding certain cells in a table can be challenging. This video shows how to sum every n rows by using the SUM and the OFFSET functions.
Рекомендации по теме
Комментарии
Автор

Saw this after spending days looking for an answer. Thank you!

sarah-ruthojames
Автор

You just saved me. Simple and straight to the point thanks!

goncalo.ferreira
Автор

Exactly what I needed, so simple when you know it haha

MetalBreakdown
Автор

Hi, I hope you ok there,
So great your formula, I applied in office 365, but I have an error in MS office 2007, error is, (#VALUE!),
So how can resolve it?

jamilahmed
Автор

I want to do the same but i want to skip months 4 ;8;12
How?

samkab
Автор

I fucking hate excel and this is not working.

lolikuh