Countifs

[jo.stanley]

I am using the following formula which works fine apart from the fact that I need it to exclude certain data

=COUNTIFS('Master Data'!A:A,A2,'Master Data'!E:E,B2,'Master Data'!F:F,C2)

What I need adding is IF Column T on 'Master Data' contains the word 'Current' Then exclude this figure from the count.

Is it possible?

 

[FormR]

Hi, just add another critieria, for example:

=COUNTIFS('Master Data'!A:A,A2,'Master Data'!E:E,B2,'Master Data'!F:F,C2,'Master Data'!T:T,"<>Current")

If if "contains the word" means there can be other text in the cell along with the word current:

=COUNTIFS('Master Data'!A:A,A2,'Master Data'!E:E,B2,'Master Data'!F:F,C2,'Master Data'!T:T,"<>*Current*")