Forum Discussion

Maggie1953

Copper Contributor

Aug 30, 2022

Solved

Help with this formula =COUNTIF($E7:$CP7, "V")

I am trying to keep track of the vacation hours my employees take. Excel has a good program that helps you count each quarter separately. However, this formula below means if I put a V in the space ...

excel

Formulas and Functions

HansVogelaar
Aug 30, 2022
Maggie1953

Perhaps

=8*COUNTIF($E7:$CP7, "V-8")+4*COUNTIF($E7:$CP7, "V-4")

HansVogelaar

MVP

Aug 30, 2022

Maggie1953

Perhaps

=8*COUNTIF($E7:$CP7, "V-8")+4*COUNTIF($E7:$CP7, "V-4")

Maggie1953

Copper Contributor

Sep 01, 2022

I cannot tell you how much this helped me to get caught up. I do have one more question. In our company, they can take vacations in any amount. We are given a certain number of hours in January, and we can use them all year in any increments. It adds all the 4/8 I put in but not the other numbers.

HansVogelaar
MVP
Sep 01, 2022
Maggie1953

Try this. If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter:

=SUM(IF(LEFT($E7:$CP7,2)="V-",-MID($E7:$CP7,2,10)))