S.o.s

[Jules513]

Hello All!

I am in need of some serious help.

I have created a spreadsheet mimicing a calendar to track Jane & John Doe's activities for the month.

Specifically I want every entry within a specified range to be tallied.

For example:

C1 Jane Doe
C2 John Doe
C3 Sally Doe

C2 through G2 represents Mon - Fri
C2 Mon D2 Tues E2 Wed F2 Thur G2 Fri

So what I'm looking for is a formula which would calculate any text entries and tally them.

SO if Jane Doe made an entry in D2, E2, F2 and no entries in either C2 or G2 what I'd like to see is the number 3 in my tally box in C43

Same with John Doe. If he made entry in C3 & G3 but nothing in the others I would like to see the number 2 in C44. etc

I hope I've explained that properly.

Thanks in advance

 

[texasalynn]

Welcome to MrExcel board....

try this

Excel Workbook
	C	D	E	F	G
1	Monday	Tuesday	Wednesday	Thursday	Friday
2		8	8.5	8.25
3	7				7
4
43		3
44		2
45
Sheet3

Excel 2003

Cell Formulas
Range	Formula
D43	=COUNTA($C2:$G2)
D44	=COUNTA($C3:$G3)

 

[Jules513]

Welcome to MrExcel board....

try this

Excel Workbook
	C	D	E	F	G
1	Monday	Tuesday	Wednesday	Thursday	Friday
2		8	8.5	8.25
3	7				7
4
43		3
44		2
45
Sheet3

Excel 2003

Cell Formulas
Range	Formula
D43	=COUNTA($C2:$G2)
D44	=COUNTA($C3:$G3)

Thank you so much for the quick response! Will this work with text? All the data entries will be text only no numbers at all.

So in Jane Doe's case
D2 Appointment w/Bob
E2 Lunch w/Ann
F2 Mtg w/James

etc

 

[texasalynn]

yes it will

Excel Workbook
	C	D	E	F	G	H	I
1	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday	Sunday
2		8	8.5	Sick
3	7		Mtg w/Ann		7
4
43		3
44		3
Sheet3

Excel 2003

Cell Formulas
Range	Formula
D43	=COUNTA($C2:$G2)
D44	=COUNTA($C3:$G3)

 

[Jules513]

ah-ha ... That's just fantastic!!

Thank you SO very much!