+ Reply to Thread
Results 1 to 2 of 2

Keeping the count of data in a cell after removing the data it counted?

  1. #1
    Registered User
    Join Date
    09-12-2018
    Location
    USA
    MS-Off Ver
    ms office 2013
    Posts
    1

    Question Keeping the count of data in a cell after removing the data it counted?

    I'm extremely new with excel and i have have searched all over the internet to try to learn how to do this. I am trying to count the amount of x's in a cell range then when those x's are removed keep the value it counted in a another cell. Basically is you have x in B7,B8,B9 Count it and put in cell T7 but when the x from B7,B8,B9 is deleted it still keeps the count in T7. When new data is added it keeps adding the count to T7.

    Currently this is what i have in T7 =COUNTIF(B7:D7,"*x*")+COUNTIF(H7:J7,"*x*")+COUNTIF(N7:P7,"*x*")
    What I have in U7 =COUNTIF(E7:G7,"*x*")+COUNTIF(K7:M7,"*x*")+COUNTIF(Q7:S7,"*x*")

    I hope this make sense.

    I posted a few screen shots of how I want it to work. Starting from the top, Starting Week Tracker, First Week Data Entry, After removing the data, and last 2nd weeks data entry.
    Examples.png

  2. #2
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: Keeping the count of data in a cell after removing the data it counted?

    You will need to use visual basic for this and write a routine to complete what you are asking. I'm a little confused as to why you would be adding and removing the X value in and out of the same cells and using this as a method to log the total number of times a cell was filled with X

    Maybe if you explain a bit more of what you're actually trying to achieve overall there will be a better solution.

    This front end table appears to be a visual aid so you might be better having a table with content so you can track the number changes to a change date.

    I'm just thinking that if someone adds and X 10 times into a cell you will have no idea when or why they were added or removed so your total becomes meaningless
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.

+ 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: 10
    Last Post: 03-28-2018, 01:07 PM
  2. First data cell not counted in pivot table...
    By Patrick4EXCEL in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 11-26-2017, 06:21 PM
  3. [SOLVED] Need Formula that dosent count if the adjacent cell was already counted in
    By Drscott21 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 03-31-2016, 12:24 PM
  4. [SOLVED] Removing Duplicates - while keeping original data series
    By tomdriscoll in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-01-2014, 08:24 PM
  5. Replies: 2
    Last Post: 08-30-2013, 06:30 AM
  6. Blank cell counted as having data
    By sallyrh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2011, 10:40 PM
  7. Replies: 6
    Last Post: 01-24-2006, 10:50 AM

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