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?

Microsoft 365 and Office | Install, redeem, activate | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,876 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' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.