function count numbers cells

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Function to count numbers of cells that has the value 'N'

Function to count numbers of cells that has the value 'N'

resolvedResolved · Low Priority · Version 2016

Sara has attended:
Excel Advanced course

Function to count numbers of cells that has the value 'N'

Id like to have a cell that indicates the number of cells whos got Y / N, how do i do that? I normal the standard count function is =COUNTA(X:X), but id like to filter out numbers of different values accordingly

RE: Function to count numbers of cells that has the value 'N'

Hi Sarah,

Thank you for the forum question.


You can use a Countif function:

=Countif(X:X,"N")

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 30 Sep 2020: Automatically marked as resolved.


 

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.12 secs.