schifferbrains
New Member
- Joined
- Jun 30, 2013
- Messages
- 2
I've got a few Excel sheets with data that looks like this:
Apr-2012
1 Apr-2012 1
2 Apr-2012 .34
3
4 Jun-2012 .8
5 Nov-2012 .2 Jan-2013 1
etc.
What this data means is this:
The first date (the heading) is the date at which a Startup "graduated" from an accelerator program
The column of numbers represent each startup in that program
The first row of dates represent the earliest dates upon which they raised money from investors
The next column represents the amount of that investment
The following column represents the NEXT date that they raised money from investors
The next column after that represents the amount they raised that time
etc.
Some cells will be blank all over the place (some companies didn't raise any money, others raised money several times, others just once).
Here are the 2 types of things I am trying to find out:
1. How many companies raised money within 3 months of graduating from the accelerator.
Logically, that would be: CountIF (the Date in column 2 or 4) is </= 3months after (date in column 1, row 1)
2. What amount was raised by the companies within 3 months of graduating from the accelerator
Sum (the amount in column 3 or 5, respectively) IF (the date in column 2 or 4, respectively) is </= 3 months after (date in column 1, row 1)
I have no idea how to write these in formulas. Little help?
Apr-2012
1 Apr-2012 1
2 Apr-2012 .34
3
4 Jun-2012 .8
5 Nov-2012 .2 Jan-2013 1
etc.
What this data means is this:
The first date (the heading) is the date at which a Startup "graduated" from an accelerator program
The column of numbers represent each startup in that program
The first row of dates represent the earliest dates upon which they raised money from investors
The next column represents the amount of that investment
The following column represents the NEXT date that they raised money from investors
The next column after that represents the amount they raised that time
etc.
Some cells will be blank all over the place (some companies didn't raise any money, others raised money several times, others just once).
Here are the 2 types of things I am trying to find out:
1. How many companies raised money within 3 months of graduating from the accelerator.
Logically, that would be: CountIF (the Date in column 2 or 4) is </= 3months after (date in column 1, row 1)
2. What amount was raised by the companies within 3 months of graduating from the accelerator
Sum (the amount in column 3 or 5, respectively) IF (the date in column 2 or 4, respectively) is </= 3 months after (date in column 1, row 1)
I have no idea how to write these in formulas. Little help?
