Yea the pivot table does not quite work.

Maybe if I give an example of what my spreadsheet looks like that will
help

_WORK_SHEET_A_ [/b]

.................................... *# OF PERSONS*

*PHONE
Week 1
week 2
week 3
week 4
week 5
week 6
week 7
week 8

PERSON/TOUR *
WEEK 1
...
...
WEEK 8

*PERSON/CANCELLED
Week 1
...
Week 8

_WORKSHEET_B_

FIRST CONTACT DATE * ....................................[b]FIRST
CONTACT TYPE
[end user must enter specific date] ..............[end user must enter
1 of 3 types: Phone, Person/Tour, Person/Enrolled]


Ok so what I need on Worksheet A is....If the type under -First Contact
Type - column on Worksheet B is a specific type on a specific date it
will show up as a count on Worksheet A. On Worksheet A the Rows titled
by week correspond to specific week. Week 1 is Aug. 15th-19th week 2 is
Aug 22-26th .... onto week 8 which is Oct 3-7th.

So for example On WorkSheet B if I input into -First Contact Date-
Column the dat of Sept 1 and then Enter on the same row but the next
column titled -First Contact Type- the entry Phone what I would like to
see happen is then on Worksheet A under the subheading Phone on the row
titled week 3 and under the column titled # of Persons a 1 will
appear....So if I make similar entry on a different row on Worksheet B
with a specific date during week 3 and entered the type again as Phone
the # of Persons count on Worksheet A would increase to two.

So what I need is a formula or a way to make this happen so I can see
by week what contact types are happening and in what amount. Later on I
am going to use this information to see what contact types have the
highest results and on what weeks.

Thanks for the help. I hope this is not confusing. I fear I will never
become a technical writer...may parents are going to be crushed... :)