Results 1 to 4 of 4

Statiscal information

Threaded View

  1. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,945

    Re: Statiscal information

    Your explanation was pretty clear right up to that last paragraph (long explanation). It describes something different than what you are saying in the list of four things you need.

    Total number of females =COUNTIF(A:A,"f")
    Total number of males =COUNTIF(A:A,"M")
    Total number of over 12s =SUM(C:C)
    Total number of under 12s =SUM(B:B)

    Because those answers are so simple, maybe your description of those four items is not detailed enough.

    Can you explain what the 3 different attendance columns mean? Does each row correspond to a single person, or some aggregation?

    Do you want to know something like: the total number of attendances for rows that are both female and under 12, and that number for each row is the total of the three attendance columns?
    Last edited by 6StringJazzer; 07-31-2011 at 04:54 PM. Reason: removed quote that didn't really need to be there in the first place
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1