+ Reply to Thread
Results 1 to 4 of 4

Make Excel count a text value and convert it to a number in another sheet

  1. #1
    Registered User
    Join Date
    04-12-2012
    Location
    Stavanger
    MS-Off Ver
    Office 365
    Posts
    39

    Smile Make Excel count a text value and convert it to a number in another sheet

    OK.. As my title says I want to be able to list up projects with different status. For this example lets use Delivered and Ongoing.
    And I need Excel to count how many Delivered and Ongoing projects there are and return the number in another sheet to be used as data for a chart.

    I've attached a sample workbook. So.. Count the status in Sheet2 and display it in Sheet1.

    Can anyone help?
    Attached Files Attached Files

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Make Excel count a text value and convert it to a number in another sheet

    Use

    =COUNTIF(Sheet2!J:J,"Delivered")

    and so on.

  3. #3
    Registered User
    Join Date
    04-12-2012
    Location
    Stavanger
    MS-Off Ver
    Office 365
    Posts
    39

    Re: Make Excel count a text value and convert it to a number in another sheet

    I tried that before posting. This message pops up: "The formula you typed contains an error" while it highlights J,"Delivered"

  4. #4
    Registered User
    Join Date
    04-12-2012
    Location
    Stavanger
    MS-Off Ver
    Office 365
    Posts
    39

    Re: Make Excel count a text value and convert it to a number in another sheet

    Solved. Typed , insted of ; ...

+ 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