variables
Posted by eric on October 20, 2001 9:23 AM
i was trying to get excel to calculate how many of the users on my system were female, but i couldnt figure out how to get it to add them seperatly...
eg: if i have a2:a6:
a2:M b2:total males
a3:F B3: total females
a4:m
.
.
Posted by Aladin Akyurek on October 20, 2001 12:03 PM
=COUNTIF(A2:A6,"M")
=COUNTIF(A2:A6,"F")
==================
