MrT2110Copper ContributorJun 21, 2022Excel help I would like to create a formula thst counts data in a column thst is above a certain value. But I only want it to count when this happens for 2 out of 3. So I want it to like at rows 1,2 and 3 ...Show More
OliverScheurichGold ContributorJun 21, 2022MrT2110 =IF(COUNTIF($D1:$D3,">"&1)=2,2,"")You can try this formula.
