Sum (Excell 2000)

Topic

New Reply

Hallo

I have a small problem which I can not seem to solve.

The problem is as follows:
I have dates in one column and figures in the next. I also have a starting and End dates in two cells. I want to sum the total from one date to the next by just changing the Start or End date.

Has this problem been solved before? Is so please direct me, I can not find anything like that unless I do not search correctly.

Any help will be appreciated.

I attached a spread sheet as sample.

Thank you

Kobus

Reply | Quote

Replies

There are several possibilities:

=SUMPRODUCT((D9:D20)*(B9:B20>=B4)*(B9:B20=B4),N(B9:B20=B4)*(B9:B20=B4)*(B9:B20<=B5),D9:D20))

The first two formulas are standard formulas; the last two are array formulas – confirm them with Ctrl+Shift+Enter instead of just Enter.

Reply | Quote

Hans

As always, you show your absolute mastery over our normal mortals.

Thank you very much.

It works perfect.

Kobus

Reply | Quote

Hans

As always, you show your absolute mastery over our normal mortals.

Thank you very much.

It works perfect.

Kobus

Reply | Quote

And of course:

=SUMIF(B9:B20,”>” & B5,D9:D20)-SUMIF(B9:B20,”<" & B4,D9:D20)

I might have missed an =, but you get the idea.

Reply | Quote

Thanks, I always forget that one.

Reply | Quote

Thanks, I always forget that one.

Reply | Quote

And of course:

=SUMIF(B9:B20,”>” & B5,D9:D20)-SUMIF(B9:B20,”<" & B4,D9:D20)

I might have missed an =, but you get the idea.

Reply | Quote

There are several possibilities:

=SUMPRODUCT((D9:D20)*(B9:B20>=B4)*(B9:B20=B4),N(B9:B20=B4)*(B9:B20=B4)*(B9:B20<=B5),D9:D20))

The first two formulas are standard formulas; the last two are array formulas – confirm them with Ctrl+Shift+Enter instead of just Enter.

Reply | Quote