+ Reply to Thread
Results 1 to 2 of 2

need help with creating formula in excel

  1. #1
    Registered User
    Join Date
    01-25-2007
    Posts
    1

    need help with creating formula in excel

    hi
    i compile attendance records for an NGO.
    in attendnace i compile attendnace of each child for three months.
    i then calculate percentages and categrise the data as 100%, 75-100%, 50-75%, 25-50% and below 25%.
    i use the frequency formula to calculate the number of children in each category. i also have a column showing whether the child is a male or female. i want to know if there is a formula that could directly give me the number of males and females in each of attendance category mentioned above.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    You could probably add a condition to your frequency formula. Can you post an example of the formulas you're using?

+ Reply to Thread

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