+ Reply to Thread
Results 1 to 3 of 3

Counting data

  1. #1
    Registered User
    Join Date
    03-19-2021
    Location
    South Africa
    MS-Off Ver
    2016
    Posts
    1

    Counting data

    Please help with Sheet 3(Assignment 2c), I do not how to calculate those using the formulas.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Counting data

    Welcome to the forum.

    Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

    We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

    If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Counting data

    We are not going to do homework for you, but I'll give you a hint. You are trying to carry out a conditional count (i.e. one which depends on criteria in other columns). This would mean using the COUNTIF (for one condition) or COUNTIFS (for multiple conditions) functions, so look for those in XL Help.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-11-2014, 12:50 PM
  2. [SOLVED] Counting specific data and extracting that data by rearranging by assigning numbering
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2014, 07:11 AM
  3. Replies: 3
    Last Post: 05-23-2014, 09:31 AM
  4. [SOLVED] Filter Data based upon multiple criteria and counting the data
    By Acidking in forum Excel General
    Replies: 5
    Last Post: 06-13-2013, 09:42 PM
  5. Replies: 6
    Last Post: 02-04-2012, 06:57 PM
  6. counting cells with data without counting duplicates
    By labettis in forum Excel General
    Replies: 2
    Last Post: 11-05-2007, 12:10 PM
  7. Counting data in non blank cells and exclude certain data from the count
    By JohnG73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-04-2007, 04:08 PM

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