Forum Discussion
Ashar2200
Jun 10, 2023Copper Contributor
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")
- OliverScheurichGold Contributor
- Ashar2200Copper ContributorThank you so much, this works for me too 🙂