+ Reply to Thread
Results 1 to 2 of 2

CountIF joined with text in one cell

  1. #1
    Registered User
    Join Date
    06-24-2016
    Location
    VA
    MS-Off Ver
    2010
    Posts
    1

    CountIF joined with text in one cell

    Not at all sure if this is possible because I cannot find anything on this anywhere, Basically what I want to do is use excel as a calendar with the X-Axis as the individual days and the Y-Axis with names of people. Each row belongs to one person and each cell is a different date. What I want to put into each cell is basically how many hours they worked in one of two positions, Say; OPS: 8 ADMIN: 4, meaning they worked 8 hours of operations and 4 hours of admin. (how this is organized in the cell is flexible)

    Is there a way to get excel to identify “OPS” with the number next to it as the associated value, then add them together for a range of days.
    Thank you for any inputs on my problem. If you need further explanation please let me know.

    Robert

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: CountIF joined with text in one cell

    Hi Robert and welcome to the forum.

    Probably the best way to start would be for you to upload a small representative Excel file (about 20 rows or so of data). (Be sure to desensitize the data). The example should reflect the real layout and data structure you are going to be using.

    1.To attach a file to your post,
    2.click “Go Advanced” (next to Post Quick Reply – bottom right),
    3.scroll down until you see “Manage Attachments”,
    4.click “Browse”.
    5.select your file(s)
    6.click “Upload”
    7.click “Close window”
    8.click “Submit Reply”
    9.The file name will appear at the bottom of your reply.
    Last edited by FlameRetired; 06-24-2016 at 10:43 PM.
    Dave

+ 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. [SOLVED] return cell values of joined arrays
    By IronCladRooster in forum Excel General
    Replies: 0
    Last Post: 09-03-2014, 09:23 AM
  2. [SOLVED] Count # of times text appears in cell range by cell referencing not =countif(A:A, ="text")
    By smit.etha in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-20-2014, 04:09 AM
  3. Using COUNTIF with text from another cell
    By Blenderr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-07-2014, 10:54 AM
  4. Replies: 2
    Last Post: 05-17-2014, 03:30 PM
  5. [SOLVED] PLEASE HELP: COUNTIF text is in the cell
    By sharmane3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2014, 03:32 PM
  6. Replies: 14
    Last Post: 07-13-2005, 07:05 PM
  7. Reference to joined cell
    By pmguerra in forum Excel General
    Replies: 0
    Last Post: 04-05-2005, 07:55 AM

Tags for this Thread

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