Forum Discussion

Ashar2200's avatar
Ashar2200
Copper Contributor
Jun 10, 2023
Solved

Count Certain value in alternate columns

Hello everyone,

 

I am trying to calculate counts of certain values in alternate columns.

 

For example - I have value 6 in a column named "expected" (in an alternate column) and I want to calculate how many of these are there. please see the reference image.


 

 

 

I am using a formula something like below but it's really lengthy and hard to keep track. can someone suggest any smart solution to this?

I just need to count how many times 2 or 4 or any value has appeared in a range of alternate columns. 

 

=COUNTIF($G5:$G5,"6")+COUNTIF($I5:$I5,"6")+COUNTIF($K5:$K5,"6")+COUNTIF($M5:$M5,"6")+COUNTIF($O5:$O5,"6")+COUNTIF($Q5:$Q5,"6")+COUNTIF($S5:$S5,"6")+COUNTIF($U5:$U5,"6")+COUNTIF($W5:$W5,"6")+COUNTIF($Y5:$Y5,"6")+COUNTIF($AA5:$AA5,"6")+COUNTIF($AC5:$AC5,"6")+COUNTIF($AE5:$AE5,"6")+COUNTIF($AG5:$AG5,"6")+COUNTIF($AI5:$AI5,"6")+COUNTIF($AK5:$AK5,"6")+COUNTIF($AM5:$AM5,"6")+COUNTIF($AO5:$AO5,"6")+COUNTIF($AQ5:$AQ5,"6")+COUNTIF($AS5:$AS5,"6")+COUNTIF($AU5:$AU5,"6")+COUNTIF($AW5:$AW5,"6")+COUNTIF($AY5:$AY5,"6")+COUNTIF($BA5:$BA5,"6")+COUNTIF($BC5:$BC5,"6")+COUNTIF($BE5:$BE5,"6")+COUNTIF($BG5:$BG5,"6")+COUNTIF($BI5:$BI5,"6")+COUNTIF($BK5:$BK5,"6")

Resources