Thread: "Sequential" summing

Hello all,
I would appreciate your help with a problem I'm having.

I have a spreadsheet with the sales info of different stores, including location of the store, time of sale, and amount. Data for all stores and sales is in one spreadsheet.

The sales are sorted by date, in a chronological order (older sales on a higher row, etc.). What I'm trying to do is to create a new column, in which next to each sale we will see the total sales in the store (including the current sale). Obviously, we need to condition the total sales to be calculated for each store separately.

I've tried doing so by using the sumif and sumifs, but couldn't get it right .

Since it's a bit hard to explain, I've uploaded this file:
http://dl.dropbox.com/u/7112203/Question-excel.xlsx
You can see the info for two stores (one in London and one in Sheffield), and on column E I calculated what I'm trying to achieve in my head.

Your help would be very appreciated,

Thank you in advance

Originally Posted by shg

In F2 and copy down,

=E2 + IF(A2=A1, N(F1))

Thank you.
Would you mind explaining the N(F1) command?
Never seen anything like it.

Thank you

Originally Posted by shg

If the first row is a header (i.e., text), then you can't add the text to the number at left; you get an error. The N function returns numbers unchanged, but converts text to 0.

It's weird, because in
=E2 + IF(A2=A1, N(F1)
you don't see anything that resembles "sum".

follow up question, if you don't mind:
how do I find, for each unique store, the time of the earliest sale? There is no "minif" function.

This is a nice vid, but doesn't cover exactly what I need: http://www.youtube.com/user/ExcelIsF.../0/Ci4ahcW1NbM

Thanks