+ Reply to Thread
Results 1 to 2 of 2

Simple summing of multiple "like" categories

  1. #1
    Registered User
    Join Date
    12-14-2004
    Posts
    1

    Simple summing of multiple "like" categories

    Hi there. I'm sure I'm not the first person to want to do this, but I am having trouble wording a query in qoogle or on this forum to find the answer to this question...

    Say i was using a spreadsheet to track a number of projects and their phases:

    PROJECT.........................PHASE
    project one.....................initiation
    project two.....................planning
    project three..................initiation
    project four....................execution
    project five....................execution

    i want to have a formula at the bottom that sums the "phase" column like so:

    Initiation.....2
    Planning.....1
    Execution....2

    How would i accomplish this? (not including the dots)

    Thanks,
    Caltrop

  2. #2
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    =countif(your range,"planning")

    for example, where your range is the range of cells where the phase is listed
    not a professional, just trying to assist.....

+ 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