#### Gekopexcel

##### New Member

- Joined
- Sep 15, 2005

- Messages
- 8

I have column A with everyday dates and column B with specific number changing everyday.

At the end of the month I have to know the total of column B for each month. For example:

A B

1 7/29/2005 7

2 7/30/2005 11

3 7/31/2005 4

4 8/1/2005 5

5 8/2/2005 8

etc

So July is 22, and august 17

Is there a formula to calculate this instead of using the +sum formula each month?

Thanks