• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
count
#1
Dear All,

Please Resolve The Question Attached Sheet.


Attached Files
.xlsx   count.xlsx (Size: 10.6 KB / Downloads: 11)
  Reply
#2
   
  Reply
#3
thankx bro
  Reply
#4
(02-Nov-2019, 09:32 AM)Mahi Singh Wrote: Dear All,

Please Resolve The Question Attached Sheet.

=SUMPRODUCT(--(MID(C6,ROW(INDIRECT("1:"&LEN(C6))),1)="p"))

it will show u correct result
  Reply


Related Topics
Topic Author Replies Views Last Post
  Others Count Vikrant8595 3 1,589 10-Nov-2019, 10:49 PM
Last Post: Vikrant8595
  Formula Count the number in one cell Amit Dhankar 4 2,402 10-Feb-2019, 12:10 AM
Last Post: Amit Dhankar
  Formula Count Working Days @m!t $@!n! 3 2,121 06-Oct-2018, 06:36 PM
Last Post: devendra_dev20
  Formula Count numbers Pradeep 2 1,985 20-Jul-2018, 10:16 AM
Last Post: Pradeep
  Formula count Lokesh GUPTA 2 2,312 14-Nov-2017, 10:57 AM
Last Post: Lokesh GUPTA
  Formula COUNT HARIOMSINGH 3 2,403 11-Nov-2017, 07:14 AM
Last Post: Vivekananda Sinha
  Formula COUNT NO OF SHEET IS WORKBOOK Lokesh GUPTA 5 3,060 09-Nov-2017, 01:33 PM
Last Post: Lokesh GUPTA
  Others Urgent::: Count if with Joints Gaurav Agarwal 3 2,496 24-Oct-2017, 12:12 PM
Last Post: Gaurav Agarwal
  Formula count Dharmesh Kumar Srivastava 5 3,227 21-Sep-2017, 08:23 PM
Last Post: Mohit Sharma
  Formula How to count odd numbers? Deepak Draverya 1 2,484 15-Sep-2017, 04:57 PM
Last Post: Lovedeep sharma
  Formula Count Absent of particular Employees Sanjeev Gupta 3 2,784 30-Aug-2017, 12:34 PM
Last Post: Lovedeep sharma
  Formula count if Deepak Draverya 3 3,042 15-Jul-2017, 06:13 PM
Last Post: Amit Negi
  Formula Count if Shankardeep 2 2,816 13-Jul-2017, 04:39 PM
Last Post: Vijay Kumar
  Formula Count Query Manish Kumar Gera 2 2,794 09-Jun-2017, 01:27 PM
Last Post: Manish Kumar Gera

Forum Jump:


Users browsing this topic: 1 Guest(s)