counting days with any function

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

Replies (4)
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

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
"
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.

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.
"

Simply GR88888888888888888888888888

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
ARTICLESHIP 16 November 2026
Audit Executives

Loonker Godawat And Company

Bengaluru

B.Com

View Details
Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details