topic Re: Excel question in QlikView https://community.qlik.com/t5/QlikView/Excel-question/m-p/511830#M690462 <HTML><HEAD></HEAD><BODY><P>I'm not sure if this is what you want but here it is.</P><P></P><P>Edit: I've changed the excel file.</P></BODY></HTML> Fri, 04 Oct 2013 12:23:51 GMT 2013-10-04T12:23:51Z Excel question https://community.qlik.com/t5/QlikView/Excel-question/m-p/511829#M690461 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Can someone please help me with the formula?</P><P></P><P>Please see attached</P><P></P><P>Thanks</P><P></P><P>Janes Krige</P></BODY></HTML> Fri, 04 Oct 2013 12:10:59 GMT https://community.qlik.com/t5/QlikView/Excel-question/m-p/511829#M690461 2013-10-04T12:10:59Z Re: Excel question https://community.qlik.com/t5/QlikView/Excel-question/m-p/511830#M690462 <HTML><HEAD></HEAD><BODY><P>I'm not sure if this is what you want but here it is.</P><P></P><P>Edit: I've changed the excel file.</P></BODY></HTML> Fri, 04 Oct 2013 12:23:51 GMT https://community.qlik.com/t5/QlikView/Excel-question/m-p/511830#M690462 2013-10-04T12:23:51Z Re: Excel question https://community.qlik.com/t5/QlikView/Excel-question/m-p/511831#M690463 <HTML><HEAD></HEAD><BODY><P>Anil,</P><P></P><P>I think you attached the same sheet I sent you, I still see only the question mark.</P><P></P><P>Regards</P></BODY></HTML> Fri, 04 Oct 2013 12:32:01 GMT https://community.qlik.com/t5/QlikView/Excel-question/m-p/511831#M690463 2013-10-04T12:32:01Z Re: Excel question https://community.qlik.com/t5/QlikView/Excel-question/m-p/511832#M690464 <HTML><HEAD></HEAD><BODY><P>Janes,</P><P></P><P>how about using</P><P></P><P>=COUNTIF(B2:B12,"a") + COUNTIF(E2:E12,"a")</P><P></P><P>Marcus</P></BODY></HTML> Fri, 04 Oct 2013 12:40:36 GMT https://community.qlik.com/t5/QlikView/Excel-question/m-p/511832#M690464 marcus_malinow 2013-10-04T12:40:36Z