Formula to total number of times a name appears on 12 tabs in a workbook

[VA_Exceluser]

I have a workbook with 12 tabs (representing 12 months). Each tab lists the name of a person and what event that person took part in that month. I would like to total the number of times the person appeared in each tab and list the even the person participated in. Is there a formula that can accomplish this?

Thanks.

 

[Herakles]

I have a workbook with 12 tabs (representing 12 months). Each tab lists the name of a person and what event that person took part in that month. I would like to total the number of times the person appeared in each tab and list the even the person participated in. Is there a formula that can accomplish this?

Thanks.

Can you use XL2BB to post the data, or some of it, from one of the sheets.

Are they all structured the same?

Why dont you keep all of the data in one sheet and use filters.

Caculations like this would be much easier.

 

[Jeffrey Mahoney]

Please try this as an example.

Where Month1 ... Month12 have a column of names in A. I entered in a few names including mine.

Book3
	A	B	C
1	Name
2	2		Month1
3			Month2
4			Month3
5			Month4
6			Month5
7			Month6
8			Month7
9			Month8
10			Month9
11			Month10
12			Month11
13			Month12
Sheet14

Cell Formulas
Range	Formula
A2	A2	=SUMPRODUCT(COUNTIF(INDIRECT("'"&C2:C13&"'!A2:A25"),"Jeff"))