Live Course on Drafting of Appeal and Reply of Penalty Notice by CA Sachin Sinha. Register Now!!

counting days with any function

RANJIT (MANAGER - ACCOUNTS) (84 Points)

30 May 2009

I hope one of you can help me in this. For counting number of days present for attendance i used countif function in the following way =COUNTIF(I27:AM27,"=P")+COUNTIF(I27:AM27,"=H"). This gives me the number of salary payable days. But if a person is present only for half a day, then i want to put small p and those cells should add only as half a day each. Please do help me on the function to be used.

Ranjit

Reply
Follow
Share

4 Replies

L KANAGARAJ (Assistant Manager-Finance) (615 Points)
Replied 30 May 2009

Originally posted by :RANJIT
"	I hope one of you can help me in this. For counting number of days present for attendance i used countif function in the following way =COUNTIF(I27:AM27,"=P")+COUNTIF(I27:AM27,"=H"). This gives me the number of salary payable days. But if a person is present only for half a day, then i want to put small p and those cells should add only as half a day each. Please do help me on the function to be used. Ranjit	"

Sir,

Your formula is o.k.

If you want half day sould add with the No. of working days simply divide the secound countif. Like =countif(I27:AM27,"=P")+countif(I27:AM27,'=H")/2.

Small p not considered, you should follow the H (half day) only.

Correct me if iam wrong

thanks

RANJIT (MANAGER - ACCOUNTS) (84 Points)
Replied 30 May 2009

Great! Thanks a lot Kanakaraj! Thank you very much! Your advice worked.

Originally posted by :L KANAGARAJ
"	Originally posted by :RANJIT " I hope one of you can help me in this. For counting number of days present for attendance i used countif function in the following way =COUNTIF(I27:AM27,"=P")+COUNTIF(I27:AM27,"=H"). This gives me the number of salary payable days. But if a person is present only for half a day, then i want to put small p and those cells should add only as half a day each. Please do help me on the function to be used. Ranjit " Sir, Your formula is o.k. If you want half day sould add with the No. of working days simply divide the secound countif. Like =countif(I27:AM27,"=P")+countif(I27:AM27,'=H")/2. Small p not considered, you should follow the H (half day) only. Correct me if iam wrong thanks	"

L KANAGARAJ (Assistant Manager-Finance) (615 Points)
Replied 30 May 2009

Originally posted by :RANJIT
"	Great! Thanks a lot Kanakaraj! Thank you very much! Your advice worked. Originally posted by :L KANAGARAJ " Originally posted by :RANJIT " I hope one of you can help me in this. For counting number of days present for attendance i used countif function in the following way =COUNTIF(I27:AM27,"=P")+COUNTIF(I27:AM27,"=H"). This gives me the number of salary payable days. But if a person is present only for half a day, then i want to put small p and those cells should add only as half a day each. Please do help me on the function to be used. Ranjit " Sir, Your formula is o.k. If you want half day sould add with the No. of working days simply divide the secound countif. Like =countif(I27:AM27,"=P")+countif(I27:AM27,'=H")/2. Small p not considered, you should follow the H (half day) only. Correct me if iam wrong thanks "	"

Sir,

This attachment also may useful one.

Attached File : 17 attendence workings.xls downloaded: 147 times

Somesh Goyal (GM) (29 Points)
Replied 27 July 2009

Originally posted by :L KANAGARAJ
"	Originally posted by :RANJIT " Great! Thanks a lot Kanakaraj! Thank you very much! Your advice worked. Originally posted by :L KANAGARAJ " Originally posted by :RANJIT " I hope one of you can help me in this. For counting number of days present for attendance i used countif function in the following way =COUNTIF(I27:AM27,"=P")+COUNTIF(I27:AM27,"=H"). This gives me the number of salary payable days. But if a person is present only for half a day, then i want to put small p and those cells should add only as half a day each. Please do help me on the function to be used. Ranjit " Sir, Your formula is o.k. If you want half day sould add with the No. of working days simply divide the secound countif. Like =countif(I27:AM27,"=P")+countif(I27:AM27,'=H")/2. Small p not considered, you should follow the H (half day) only. Correct me if iam wrong thanks " " Sir, This attachment also may useful one.	"