COUNTIFS formula with INDEX/MATCH column

[horizonflame]

Hi All

=COUNTIFS(DataWork!$A$3:$A$10000,"*CDITT*",DataWork!$Q$3:$Q$10000,"*",DataWork!$P$3:$P$10000,"<"&TODAY())

DataWork Column Q contains INDEX/MATCH formula results, am I right in thinking that is why this formula returns a count of zero?

Many thanks

 

[salim hasan]

I THINK THE RIGHT FORMULA MUST BE LIKE THIS

[COLOR=#333333][I]=COUNTIFS(DataWork!$A$3:$A$10000,"*"&"CDITT"&"*",DataWork!$Q$3:$Q$10000,"?*",DataWork!$P$3:$P$10000,"<"&TODAY())[/I][/COLOR]

 

[salim hasan]

I THINK THE RIGHT FORMULA MUST BE LIKE THIS
1--IF DataWork!$Q$3:$Q$10000 CONTAINS TEXT

[COLOR=#333333][I]=COUNTIFS(DataWork!$A$3:$A$10000,"*"&"CDITT"&"*",DataWork!$Q$3:$Q$10000,"?*",DataWork!$P$3:$P$10000,"<"&TODAY())[/I][/COLOR]

2--IF DataWork!$Q$3:$Q$10000 CONTAINS NUMBERS

[I]=COUNTIFS(DataWork!$A$3:$A$10000,"*"&"CDITT"&"*",DataWork!$Q$3:$Q$10000,[/I]"<="&10^9[I],DataWork!$P$3:$P$10000,"
[/I]

 

[Fluff]

@salim hasan
Please do not make duplicate posts.
Also in future please do not us capital letters as that is SHOUTING and is considered rude.
Thanks

 

[horizonflame]

@salim hasan, thank you but the number solution is not working for me.

 

[horizonflame]

I have found that the COUNT function will count the number of cells in column Q with matches found. Could this be incorporated into my formula at all?

=COUNTIFS(DataWork!$A$3:$A$10000,"*CDITT*",DataWork!$Q$3:$Q$10000,(COUNT))

Many thanks again

 

[salim hasan]

@salim hasan
Please do not make duplicate posts.
Also in future please do not us capital letters as that is SHOUTING and is considered rude.
Thanks

I know this very well
But I made a mistake in the first Post and I don't know how to delete it