Forum Discussion

gthistlethwaite's avatar
gthistlethwaite
Frequent Visitor
8 years ago
Solved

CountRows of Multiple Columns

I have 4 columns of data. I need to sum the 4 columns based on a text value.   I was able to perform on 1 column, but then receive an error trying to add these together.   AsiaTTL = COUNTROWS(FI...
  • gthistlethwaite's avatar
    gthistlethwaite
    8 years ago

    Fixed now, it required an extra closing bracket before the next +COUNTROWS:

     

    AsiaTTL = COUNTROWS(FILTER('QHSE Award Voting','QHSE Award Voting'[Cat1]="Asi"))+COUNTROWS(FILTER('QHSE Award Voting','QHSE Award Voting'[Cat2]="Asi"))+COUNTROWS(FILTER('QHSE Award Voting','QHSE Award Voting'[Cat3]="Asi"))+COUNTROWS(FILTER('QHSE Award Voting','QHSE Award Voting'[Cat4]="Asi"))

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

I'm not sure why you are using a filter here, wouldn't countrows(tablename,cat1="Asia") work for each section of your formula?

 

Also, are you wanting it so that if Asia's entered in more than one column for a given row it counts more than once?

gthistlethwaite's avatar
gthistlethwaite
Frequent Visitor
8 years ago

The table is survey results with multiple columns.