Avatar of Frank .S
Frank .S
Flag for Australia

asked on 

count formula _1

hi experts, can you help me with a formula for the following;

    AB          y
    AC          n
    SC          y
    JM          n
   total       x 2

to count/sum 1 for each cell value with a "y", and to display total as x 2, so the formula needs to be in the "x 2" cell
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon