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 calcul...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 10, 2023

    Ashar2200 

    =SUMPRODUCT((ISODD(COLUMN(G:BK)))*(G5:BK5=6))

     

    This works in my sheet.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 10, 2023

Ashar2200 

=SUMPRODUCT((ISODD(COLUMN(G:BK)))*(G5:BK5=6))

 

This works in my sheet.

  • Ashar2200's avatar
    Ashar2200
    Copper Contributor
    Jun 11, 2023
    Thank you so much, this works for me too 🙂

Resources