Excluding specific criteria

datadummy

Board Regular
Joined
Mar 16, 2017
Messages
247
Office Version
  1. 365
Platform
  1. Windows
I have a countifs statement that is counting all data in one column, but I need to add to the statement that excludes any data in column L that has Expired in the cell.
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
You can add a criteria using the <> operator...

=COUNTIFS(L:L,"<>Expired")
 

cerfani

Well-known Member
Joined
Dec 15, 2014
Messages
1,136
you really didnt provide any info on what your sheet looks like and what you are trying to do but anyways dates are numbers so you can use comparison operators <>= to test them
 

Watch MrExcel Video

Forum statistics

Threads
1,118,398
Messages
5,571,893
Members
412,423
Latest member
monbri9931
Top