Counting and summing problem

[Saleena]

Hello,

This is where I come when I can't get my head wrapped around an Excel problem. Y'all are the greatest. Thanks!

Ok, I've got this report I'm working on. The format is set so there isn't any feasible way to split the information that's in a single column into multiple columns. Now I need to do the summary data for the report. For each entry in the report, in Column B the information is stacked. First row (Col B) has "Center Name", second row (Col B) has "County", third row (Col B) has "Slots A" (formatted like ###, followed by 3 text characters), fourth row has "Slots B" (formatted like ###, followed by 4 text characters), fifth row has "Staff" (formatted like ###, followed by 6 text characters), sixth row is blank. Then it starts over again. The total number of entries in the report is unknown and dynamic.

I need to count the number of different counties and total "Slots A", "Slots B", and "Staff". I don't have any idea of an efficient way to code this. Can y'all help me out?

 

[hiker95]

Saleena,

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[Saleena]

Thanks for the link. Also, I forgot to say that this is Excel 2003. Sample sheet is below:

Excel Workbook
	A	B	C	D	E	F
7
8	Impact Summary:	Counties:		Centers:
9	HS Slots:		EHS Slots:		Staff:
10
11	Grantee Name, Address & Contact Information	Center Name, County, #s Impacted	Center Status & Projected Reopen Date	Damage Details	Cost Estimate	Comments
12	Grantee Name	East YMCA		Unknown at first report	$1,500.00	Likely to be more costly; will update information as more is available.
13	Address 1	Montgomery	Closed:
14	Address 2	60 HS	2/12/2010
15	City, State Zip	0 EHS	Reopen:
16	Contact Name	7 Staff	2/16/2010
17	Contact Email
18	Contact Phone	Dean Elementary School		Roof blown off	$30,000.00	N/A
19		Montgomery	Closed:
20		20 HS	2/12/2010
21		0 EHS	Reopen:
22		3 Staff	3/12/2010
Report

Again, I need to count the number of counties and add the total HS slots, the total EHS slots and the total staff.

 

[Saleena]

Oh...I also need to count the number of centers, but if I can get one of those adds to work right, I'm sure I can translate it to the others.

 

[hiker95]

Saleena,

See my Private Message to you (top right hand corner of MrExcel, Welcome, Saleena., "Private Messages:".