G
ghost
Greeting,
I have the following table in 5 sheets (Summary, Jan, Feb, March & Aprial).
Sheet (Jan)
Employee ID Name No. of Absent
1 John 1
2 aaa 2
3 bbb 1
Sheet (Feb)
Employee ID Name No. of Absent
1 John 3
2 aaa 1
3 bbb 4
..
..
..
..
So on.
What I want to do is how to summarize the above table as follows by using
sum if or count if:
Sheet (summary)
Employee ID Name Absent Total
1 John 4
2 aaa 3
3 bbb 5
I have the following table in 5 sheets (Summary, Jan, Feb, March & Aprial).
Sheet (Jan)
Employee ID Name No. of Absent
1 John 1
2 aaa 2
3 bbb 1
Sheet (Feb)
Employee ID Name No. of Absent
1 John 3
2 aaa 1
3 bbb 4
..
..
..
..
So on.
What I want to do is how to summarize the above table as follows by using
sum if or count if:
Sheet (summary)
Employee ID Name Absent Total
1 John 4
2 aaa 3
3 bbb 5