SUM FOR GENDER = m

[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

 

[Max]

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

#value

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]

 

[Frank Kabel]

Hi
try
0SUMPRODUCT(--(totpoints>0),--(gender="M"))

 

[Peo Sjoblom]

Unless there are negative values

=SUMIF(Gender,"M",Totpoints)

--


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

Regards,

Peo Sjoblom