+ Reply to Thread
Results 1 to 4 of 4

Countif formula show error when Run code on Selected cells

  1. #1
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Countif formula show error when Run code on Selected cells

    Hi friends

    Please help me how to run code after selection of cells with countif formula

    Thanks

    imran

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by internet_imran; 12-01-2015 at 10:40 AM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Countif formula show error when Run code on Selected cells

    Change

    J3=countif(3:3;"*LPIT*")

    into

    J3=countif(H3:H3;"*LPIT*")
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Countif formula show error when Run code on Selected cells

    B'cos your current J3 cell formula (=COUNTIF(3:3,"*LPIT*")) encountering Circular Reference error. Because your formula is trying to calculate its own cell.


    Change your J3 Cell formula to the below one.

    =COUNTIF(A3:I3,"*LPIT*")


    To know more about Circular Reference Error:-

    https://support.office.com/en-us/art...f34-d1d9-427a-
    926b-6e1b64e1ac0b


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Forum Contributor
    Join Date
    12-24-2005
    Posts
    104

    Re: Countif formula show error when Run code on Selected cells

    Thank you very much Sixthsense & oeldere .

+ 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. can you show formulas in selected cells only of a worksheet?
    By covenantdanes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2013, 10:26 AM
  2. [SOLVED] Countif error of selected cells
    By BadKornFlake in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-09-2012, 01:12 PM
  3. Replies: 4
    Last Post: 10-03-2011, 05:54 AM
  4. conter to show how many cells are selected
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2010, 02:04 PM
  5. Show gridlines only in selected cells
    By johnlovesbeer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-17-2009, 05:36 AM
  6. Cells don't show up online until cell is selected.
    By mickiedevries in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-29-2007, 04:10 PM
  7. Is there a formula to show which cell is currently selected
    By Chris in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2006, 10:40 AM
  8. show sum of selected cells
    By derwood in forum Excel General
    Replies: 2
    Last Post: 11-23-2005, 05:40 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