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.
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.
Last edited by internet_imran; 12-01-2015 at 10:40 AM.
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.
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
Thank you very much Sixthsense & oeldere .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks