Share via

I would like to include a Total at the bottom of a column based on critieria (active)

Tasheena Parker 0 Reputation points
2023-03-28T14:34:39.8533333+00:00

I created a list and want a total for a column to display at the bottom but I only want it to calculate the total number of rows with an "active status".

We still keep inactive employees' information, but I don't want those employees included in the calculation. I didn't want to have to create another column if possible. Is there a way to do this?

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,118 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,636 Reputation points
    2023-03-29T02:07:06.5+00:00

    Hi @Tasheena Parker

    Does this list in Excel workbook?

    Could you please share us with a simple sample for better analysis?

    I suggest you try Countif function to get this total number.

    According to following sample, the formula could be =COUNTIF(B1:B5,"Active Status").

    Capture73

    Any misunderstandings or updates, please feel free to post back.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.