https://community.splunk.com/t5/Splunk-Search/implement-excel-countif-function-in-Splunk/m-p/341949#M101333 <P>Try:<BR /> <CODE>| stats count as Count_Root_values by ROOT_value</CODE></P> <P>If you want to keep the original data as well, you could try <CODE>eventstats</CODE> instead of <CODE>stats</CODE>. But that will not give you the exact result from your example, as it will put the count on each row. Why exactly is that a problem?</P> Thu, 19 Apr 2018 08:18:22 GMT FrankVl 2018-04-19T08:18:22Z https://community.splunk.com/t5/Splunk-Search/implement-excel-countif-function-in-Splunk/m-p/341948#M101332 <P>Hi All,</P> <P>Following is my source table (pelase consider the first 2 fields:- Value and Root_Value only):- <IMG src="https://community.splunk.com/storage/temp/240624-sorceimage.jpg" alt="alt text" /></P> <P>I want to find the count of values based on root values and store it a new field Count_Root_Values.The output should look like this <BR /> <IMG src="https://community.splunk.com/storage/temp/240625-needeoutput.jpg" alt="alt text" /></P> <P>In excel, there is formulla for it :- =IF(COUNTIF(B$2:B2; B2)=1;COUNTIF(B:B; B2);TEXT(;)) .<BR /> In Splunk, I am trying to use the eval to generate the new field and stats count(Value) by ROOT_Value to find the number. But I really missing the iterative process to fin the count only once. </P> Tue, 29 Sep 2020 19:04:26 GMT https://community.splunk.com/t5/Splunk-Search/implement-excel-countif-function-in-Splunk/m-p/341948#M101332 Chandras11 2020-09-29T19:04:26Z https://community.splunk.com/t5/Splunk-Search/implement-excel-countif-function-in-Splunk/m-p/341949#M101333 <P>Try:<BR /> <CODE>| stats count as Count_Root_values by ROOT_value</CODE></P> <P>If you want to keep the original data as well, you could try <CODE>eventstats</CODE> instead of <CODE>stats</CODE>. But that will not give you the exact result from your example, as it will put the count on each row. Why exactly is that a problem?</P> Thu, 19 Apr 2018 08:18:22 GMT https://community.splunk.com/t5/Splunk-Search/implement-excel-countif-function-in-Splunk/m-p/341949#M101333 FrankVl 2018-04-19T08:18:22Z