Need to get running total of members

[JTL9161]

I have a roster of members that have joined our non-profit organization. I have their start date and for some their end date. I think I am looking for a formula but just can't figure it through.

I'm trying to get a running total of number of members per quarters starting with our first members way back in 1960 and running to the current date.

For example: For the first quarter of 1960 we had 10 members then in the 2nd quarter of that same year we gained 3 more but lost 1 net 2 so our total as of 2nd Quarter of 1960 was 12.

Looking to do that through today's date where we currently have 60 members.

Like I said I think it would be a formula or sub total per quarter but again can't get through it. The formula would read the start date in column C and then the stop dates (if there is one) in column D and give me the + or - members and the net total. First and last names are in column A & B.

Any help would be appreciated.
Thank You,
James

 

[wideboydixon]

First shot based on my understanding of your requirements:

Book1
	A	B	C	D	E	F	G	H
1	Firstname	Surname	Start	End		Date	Members	Net change
2	Alfie	Adams	01/01/1960			03/31/1960	3	+3
3	Bob	Brown	01/01/1960			06/30/1960	5	+2
4	Charlie	Collins	04/04/1960			09/30/1960	7	+2
5	David	Davies	04/04/1960			12/31/1960	8	+1
6	Eric	Eccles	01/01/1960	11/11/1960		03/31/1961	7	-1
7	Frank	Fylde	08/08/1960			06/30/1961	7	0
8	George	Graham	08/08/1960			09/30/1961	7	0
9	Hetty	Haynes	12/12/1960			12/31/1961	7	0
10	Isaac	Isaacson	12/12/1960	03/03/1961		03/31/1962	7	0
Sheet2

Cell Formulas
Range	Formula
F2	=DATE(1960+INT((ROWS($F$2:$F2)-1)/4),MOD(ROWS($F$2:$F2)-1,4)*3+4,1)-1
H2	=G2-N(G1)
G2	{=SUM(IF($C$2:$C$10<=$F2,IF($D$2:$D$10="",1,IF($D$2:$D$10>$F2,1,0))))}
Press CTRL+SHIFT+ENTER to enter array formulas.

WBD

 

[JTL9161]

Looks good. I will give it a try. Thanks!

 

[JTL9161]

Works pertfect! Thank you.

 

[wideboydixon]

Cool! I wasn't expecting to get this first time

WBD