Discussion Board for collaboration on QlikView Scripting.
I need a single nr in H1 of the total amount of 'a' (Correct marks) in the two columns, as I add a's, the nr must increase.
Can someone please help me with the formula?
Please see attached
I'm not sure if this is what you want but here it is.
Edit: I've changed the excel file.
I think you attached the same sheet I sent you, I still see only the question mark.
how about using
=COUNTIF(B2:B12,"a") + COUNTIF(E2:E12,"a")