Well il +rep a billion times for this, im doing a 18th party cos my 18th is soon, im doing a guestlist on spreadsheet by doing the names in the 1st colum and the second colum there sex, im trying to work out how many males to females. can someone help me do this
Ross
Results 1 to 6 of 6
Thread: HELPP SPREADSHEEETTT
-
19-09-2009, 02:48 PM #1
- Join Date
- Oct 2005
- Location
- Spain, Valencia
- Posts
- 20,492
- Tokens
- 3,575
- Habbo
- GoldenMerc
HELPP SPREADSHEEETTT
-
19-09-2009, 03:05 PM #2
- Join Date
- Mar 2008
- Location
- Halifax NS, Alpine NJ (USA)
- Posts
- 2,766
- Tokens
- 2,318
What I would do is have their names in column one, male in column 2 and female in column 3. Then when you're all done @sum the male column and then do the same for the female column.
I'm at a point in my life where I don't care if you like me or you don't. If you like me, cool. If you don't, meh.
-
19-09-2009, 03:07 PM #3
- Join Date
- Oct 2005
- Location
- Spain, Valencia
- Posts
- 20,492
- Tokens
- 3,575
- Habbo
- GoldenMerc
Thats a pretty good ideaaa
ty, il try it then rep u
-
19-09-2009, 03:24 PM #4
could you not sort it by the gender column and then highlight all the males and work out how many there are from the range selected? Then for females just the total number of rows minus males ?
cake
-
21-09-2009, 04:54 PM #5
http://www.ryanclark.me/Party.xlsx
try that.
-
Metric1, Blob and infrequent, there is a shorter way to skin the cat. If you use the COUNTIF function, you don't need to use more than one column for gender. ^_^
http://drop.io/h8zwoqb/asset/test-xls
Edit: The functions used in the total cells would be something along the lines of
Code:=COUNTIF(B:B, "Male")
Last edited by Barmi; 21-09-2009 at 08:16 PM.
Reply With Quote
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts