Support Board

Date/Time: Sun, 19 May 2024 09:17:02 +0000

Post From: spreadsheet countif alternative

[2017-01-07 20:06:09] Link To Thread - Link To Post [Go To First Post]
BearDown - Posts: 2
I need to find a way to count the number of occurrences of a specific value in a range. I tried your alternative "The formula =COUNTIF(AA3:AA12,">50") can be implemented in the non-CLR version as follows: In one of the spreadsheet formula columns enter this formula =IF(AA3>50,1,0). Assuming the prior formula was entered in formula column X, then enter =SUM(X3:X12) in another formula column. The result of this last formula will be the same as =COUNTIF(AA3:AA12,">50")." However, this does not apply to me because you are using the =SUM function. I also tried without using the 'SUM' so it was just =(X3:X12) and that didn't work either. I want to do the following which is basically searching a range A1:A5. A1 = 2000 A2 = 2001 A3 = 2000 A4 = 2000 A5 = 2001 =COUNTIF(A1:A5, 2000) This would return 3 because there are 3 occurrences of 2000. Please Please Please help...