Please tell me the formula!!

[Romburg]

Hello. I can`t sum count the duplicate values(for example: "q") ​​in different columns(a,b,c,d...) of table mex((( Please help somebody! And I'm sorry for my english)
Example:
col.| a b с d ...
val.| q d d q ...

myvar.:
if {mex.a} like "q"
then yes
else
no
and then INSERT SUMMARY BUT
its too long for each column.

thanks in advance!)

 

[LaurieHamlin]

Let me make sure I understand. You want to add all the values in Column A, except for duplicates?
What version are you working with and where is the data?