Thread: COUNTIFS formula with INDEX/MATCH column Thanks: 0 Likes: 0

1. COUNTIFS formula with INDEX/MATCH column

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

2. Re: COUNTIFS formula with INDEX/MATCH column

I THINK THE RIGHT FORMULA MUST BE LIKE THIS
Code:
`=COUNTIFS(DataWork!\$A\$3:\$A\$10000,"*"&"CDITT"&"*",DataWork!\$Q\$3:\$Q\$10000,"?*",DataWork!\$P\$3:\$P\$10000,"<"&TODAY())`

3. Re: COUNTIFS formula with INDEX/MATCH column

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

Code:
`=COUNTIFS(DataWork!\$A\$3:\$A\$10000,"*"&"CDITT"&"*",DataWork!\$Q\$3:\$Q\$10000,"?*",DataWork!\$P\$3:\$P\$10000,"<"&TODAY())`
2--IF DataWork!\$Q\$3:\$Q\$10000 CONTAINS NUMBERS

Code:

Code:
```=COUNTIFS(DataWork!\$A\$3:\$A\$10000,"*"&"CDITT"&"*",DataWork!\$Q\$3:\$Q\$10000,"<="&10^9,DataWork!\$P\$3:\$P\$10000,"
```

4. Re: COUNTIFS formula with INDEX/MATCH column

@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

5. Re: COUNTIFS formula with INDEX/MATCH column

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

6. Re: COUNTIFS formula with INDEX/MATCH column

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

7. Re: COUNTIFS formula with INDEX/MATCH column

Originally Posted by 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
I know this very well
But I made a mistake in the first Post and I don't know how to delete it

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•