Excel 2007 : =sum problem

[Dr.Appalayya]

I have attached a file.

I am classifying 45 respondents (M,F) into categories "1" and "0" V2:V46 on gender basis(b2:b)46. I have used =sum formula, but I am not getting account for all 45 respondents. The formula is giving result for 35 respondents only.

The formulas I have used are:

=SUM((B2:B46="M")*(V2:V46=1))
=SUM((B2:B46="F")*(V2:V46="1"))
=SUM((B2:B46="M")*(V2:V46=0))
=SUM((B2:B46="F")*(V2:V46="0"))

I have entered them C+S+E press.

Please point out my error.

[Andy Pope]

For some reason you have wrapped the 1 in quotes for the Female test.
Use,

=SUM((B2:B46="F")*(V2:V46=1))

[DonkeyOte]

If as implied by your upload you're running 2007 you should use COUNTIFS (non-array) in preference to CSE, eg

=COUNTIFS(B2:B46,"F",V2:V46,1)

However, unlike the Array (or SUMPRODUCT equiv.) the COUNTIFS function is not backwards compatible with earlier versions of XL (it is however more efficient).