Results 1 to 2 of 2

Excel 2007 : Count if question

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Florida US
    MS-Off Ver
    Excel 2007
    Posts
    96

    Count if question

    HI,
    I received help before and thought I could apply it across all instances I needed but can not, so if more help is available, thank you in advance!

    I need to count entries (from registrations) on a chart by two different categories, defined by text entries, such as people who work in middle school and are in the math department.

    The categories are colums with options for
    Subject area
    Math
    Science
    CTE
    Leadership (Administrator)
    Reading
    Language Arts
    Social Studies

    Instructional Level
    Elementary
    Middle School
    High School


    I am using
    Formula: copy to clipboard
    =SUM(($G$2:$G$287="Elementary")*($H$2:$H$287="Math")+($G$2:$G$287="Elementary"))
    but it does not work. The spreadsheet is attached.

    Thanks for any help you can offer!
    Attached Files Attached Files

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