Excel Formula Query on Summing Annual Leave Days and Half Days

0 votes

I'm making leave trackers for several of my staff. This tracker keeps tabs on sick days, partial days, parental leaves, annual leaves, and work-from-home days.

Each of the 12 tabs represents a month of the calendar and highlights the days and dates. At the bottom of each tab is a total column that counts the number of annual leaves and half-days only (as the others are not deducted from their annual allowance).

Annual Leaves = A

Half Days = HA

Is there a formula I can use, to sum up the annual leaves and half days for each employee where half days is equal to 0.5 of a day rather than a day? So if one has 2 days of annual leave in January and 3 half-day leaves in January; what formula can I use to show 3.5?

Oct 3, 2022 in Others by Kithuzzz
• 38,010 points
1,616 views

1 answer to this question.

0 votes
Try Something like =SUM(COUNTIF($A$1:$A$8,"A"),COUNTIF($A$1:$A$8,"HA")/2) - total count of A, and total count of HA divided by 2.
answered Oct 3, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

datatable remove column on export to pdf and excel

When we are using jquery datatable for ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
3,865 views
0 votes
1 answer

VBA, Query Vertica database and populate to excel

You can query Vertica directly from excel. I ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,720 points
1,079 views
0 votes
1 answer

Excel formula to check date within this week and last week

Assuming the first date in A2 try this formula ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,720 points
1,604 views
0 votes
1 answer
0 votes
1 answer

How to use COUNTIFS with multiple conditions and columns in Excel?

Use  SUMPRODUCT and double unay operators: =SUMPRODUCT ...READ MORE

answered Apr 4, 2023 in Others by Kithuzzz
• 38,010 points
413 views
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,720 points
660 views
0 votes
1 answer

Excel COUNTIF "Column D" year equals 2015 and Column L equals "15 or greater"

COUNTIFS() with an S allows the ability of multiple ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
780 views
0 votes
1 answer

How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE

answered Nov 26, 2022 in Others by narikkadan
• 63,720 points
487 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,720 points
1,077 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP