Excel question

[#1]

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

[#2]

I'm not sure if this is what you want but here it is.

Edit: I've changed the excel file.

[#3]

Anil,

I think you attached the same sheet I sent you, I still see only the question mark.

Regards

[marcus_malinow]

Janes,

how about using

=COUNTIF(B2:B12,"a") + COUNTIF(E2:E12,"a")

Marcus