SUM FOR GENDER = m

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

Hi,
I am trying to set up a spreadsheet counting scores for the male
and females seperately
for following totpoints and gender are assigned names


I am using sumif((totpoints>0)*(gender="M")) but am coming up wit
#value

both totpoints and gender are correctly assigned

thankyou in advanc
 
I am using sumif((totpoints>0)*(gender="M")) but am coming up with
#value
Click to expand...

Try SUMPRODUCT?

For example:

=SUMPRODUCT((Totpoints>0)*(Gender="M"))
[to count the no. of males with points>0]

=SUMPRODUCT((Totpoints>0)*(Gender="M"),Totpoints)
[to sum the total points for males with points>0]
 
Unless there are negative values

=SUMIF(Gender,"M",Totpoints)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top