mrkris1982
Active Member
- Joined
- Apr 16, 2009
- Messages
- 407
I have a date column formatted in mm/dd/yyyy
I have a chart that I want to automatically update as I enter data into the spreadsheet. Here's what I'm looking for help on:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD][TABLE="width: 224"]
<tbody>[TR]
[TD="width: 224"]Jobs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Income[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD]count if column A begins with 8[/TD]
[TD][TABLE="width: 305"]
<tbody>[TR]
[TD="width: 305"]SUM column J if adjacent column A begins with 8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD]count if column A begins with 9[/TD]
[TD][TABLE="width: 305"]
<tbody>[TR]
[TD="width: 305"]SUM column J if adjacent column A begins with 9[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD]count if column A begins with 10[/TD]
[TD][TABLE="width: 305"]
<tbody>[TR]
[TD="width: 305"]SUM column J if adjacent column A begins with 10[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD]count if column A begins with 11[/TD]
[TD]SUM column J if adjacent column A begins with 11[/TD]
[/TR]
</tbody>[/TABLE]
What formulas can I use to accomplish this?
Thanks in advance
I have a chart that I want to automatically update as I enter data into the spreadsheet. Here's what I'm looking for help on:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD][TABLE="width: 224"]
<tbody>[TR]
[TD="width: 224"]Jobs[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Income[/TD]
[/TR]
[TR]
[TD]August[/TD]
[TD]count if column A begins with 8[/TD]
[TD][TABLE="width: 305"]
<tbody>[TR]
[TD="width: 305"]SUM column J if adjacent column A begins with 8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]September[/TD]
[TD]count if column A begins with 9[/TD]
[TD][TABLE="width: 305"]
<tbody>[TR]
[TD="width: 305"]SUM column J if adjacent column A begins with 9[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]October[/TD]
[TD]count if column A begins with 10[/TD]
[TD][TABLE="width: 305"]
<tbody>[TR]
[TD="width: 305"]SUM column J if adjacent column A begins with 10[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]November[/TD]
[TD]count if column A begins with 11[/TD]
[TD]SUM column J if adjacent column A begins with 11[/TD]
[/TR]
</tbody>[/TABLE]
What formulas can I use to accomplish this?
Thanks in advance