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 1,478 views

## 1 answer to this question.

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
• 63,700 points

## datatable remove column on export to pdf and excel

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

## VBA, Query Vertica database and populate to excel

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

## Excel formula to check date within this week and last week

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

## Creating an Instagram bot with reading an excel file and posing on Instagram, but some of words can not be read properly

The (account name) test1 100 euro #mountain ...READ MORE

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

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

## Excel COUNTIF formula

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

## 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

## How to simplify adding multiple countifs formula in excel

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

## 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

## How to build a custom column formula in Power query that will retrieve Image and load it to Excel to display that image from the specified column

Make sure ignore privacy is selected in ...READ MORE