count formula for pivot table

[faizee]

I need the calculate formula for pivot table


there are numbers and "Absent" in the fields,,. so i want to count "absent"

field name is "time-in"

 

[Robert Mika]

I need the calculate formula for pivot table


there are numbers and "Absent" in the fields,,. so i want to count "absent"

field name is "time-in"

Could you post a sample of your data?

 

[faizee]

Card no	Date	time in	Time out
11	1-Feb-12	11:23	19:34
11	2-Feb-12	absent
10	1-Feb-12	6:44	20:33
11	5-Feb-12	9:00	18:22
11	6-Feb-12	absent
10	17-Mar-12	8:34	19:00
count "absent" in (time In)
in pivot table
Card no	12-Feb	12-Mar
11	2	0
10	0	0

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=2></COLGROUP>

 

[Robert Mika]

Card no	Date	time in	Time out
11	1-Feb-12	11:23	19:34
11	2-Feb-12	absent
10	1-Feb-12	6:44	20:33
11	5-Feb-12	9:00	18:22
11	6-Feb-12	absent
10	17-Mar-12	8:34	19:00
count "absent" in (time In)
in pivot table
Card no	12-Feb	12-Mar
11	2	0
10	0	0

Add another column which count the number of absent:

Excel Workbook
	A	B	C	D	E
1	Card no	Date	time in	Time out	Absent
2	11	01-Feb-12	11:23	19:34	0
3	11	02-Feb-12	absent		1
4	10	01-Feb-12	06:44	20:33	0
5	11	05-Feb-12	09:00	18:22	0
6	11	06-Feb-12	absent		1
7	10	17-Mar-12	08:34	19:00	0
8
9
10
11
12		Sum of Absent	Column Labels
13		Row Labels	Feb	Mar
14		11	2
15		10	0	0
Sheet3

 

[faizee]

ooh thats a good idea,

thanks
i just to ask, cant we directly put count or vlookup formula in pivot table --> formula--> calcuated field

 

[faizee]

is anyone here. who could help me in it..