Count data from single column with different condition

[nishant859@yahoo.co.in]

Hi All,

I want to Count Data from a single column say F with multiple condition like all the cell equal to either "suspected fraud" or "fraud" or "fraud booking" or "fraud location" or "previous fraud"

using multiple condition with data also

like how many above mentioned type of frauds we have in specific Date (Date in Column A)

And

Please let me know, in all the above mentioned criteria, we have "Fraud" as a Common word, so can we count cell using just "Fraud"..


Pls Note ::-

I am using currently wildcard operater, but getting error in some situation

COUNTIFS(A1:A1151,A1153,E1:E1151,"*Fraud*")

&& I can also add different countifs but actually want to learn something new


Thanks

 

[Hui]

Nishant


You could use something like:

=SUMPRODUCT(IFERROR(FIND("Fraud",E1:E1151),0))

Ctrl Shift Enter