Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Thanks
Janes Krige
I'm not sure if this is what you want but here it is.
Edit: I've changed the excel file.
Anil,
I think you attached the same sheet I sent you, I still see only the question mark.
Regards
Janes,
how about using
=COUNTIF(B2:B12,"a") + COUNTIF(E2:E12,"a")
Marcus