Where is this 'count responses' code failing?

[henryBukowski]

Hello,

As you can see below, I have used 15 variables to store the counts for different combinations in response to the question "Have you ever been a member of the armed forces?"

My output table is the problem because it groups responses by gender, separating men who have served in the forces, from women who have served etc.

It outputs the final counts into a table, HOWEVER.

Any response other than male fails to work and the output is always 0.

Can anybody help correct the below code?

Please Login or Register  to view this content.

Linked Post: http://www.mrexcel.com/forum/excel-q...ml#post3814373

[nathansav]

Is it erroring or just not doing what you want? If so can you show where the error occurs.

Also, i've notice that you are looking for strings in title case, could it be "male" rather than "Male", i use option compare text to ignore the case, or you could say if lcase(xxxxx)="male"

[romperstomper]

It's the nesting of the If clauses. See my response in the linked thread.