1. ## Sum (Excell 2000)

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

2. ## Re: Sum (Excell 2000)

There are several possibilities:

=SUMPRODUCT((D920)*(B9:B20>=B4)*(B9:B20<=B5))

=SUMPRODUCT(D920,N(B9:B20>=B4),N(B9:B20<=B5))

=SUM((D920)*(B9:B20>=B4)*(B9:B20<=B5))

=SUM(IF((B9:B20>=B4)*(B9:B20<=B5),D920))

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

3. ## Re: Sum (Excell 2000)

Hans

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

Thank you very much.

It works perfect.

Kobus

4. ## Re: Sum (Excell 2000)

And of course:

=SUMIF(B9:B20,">" & B5,D920)-SUMIF(B9:B20,"<" & B4,D920)

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

5. ## Re: Sum (Excell 2000)

Thanks, I always forget that one.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•