• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Countif and countifs
#1
Hi,

How to use countif or countifs if data contains in double quote?

For Example:

A35 Samsung 40" Smart
A25 Samsung 24"
A65 Samsung 40" Smart
A25 Samsung 24"
  Reply
#2
Please attach a sample excel file.
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Reply
#3
(14-Jul-2017, 07:52 PM)Vivekananda Sinha Wrote: Please attach a sample excel file.

File Attached


Attached Files
.xlsx   Sample file.xlsx (Size: 9.39 KB / Downloads: 20)
  Reply
#4
(19-Jul-2017, 04:18 PM)LB Vishwakarma Wrote:
(14-Jul-2017, 07:52 PM)Vivekananda Sinha Wrote: Please attach a sample excel file.

File Attached

Hi LB,

Please check attached response, I hope this will resolve your question.


Attached Files
.xlsx   Sample file-1.xlsx (Size: 14.49 KB / Downloads: 13)
  Reply
#5
Hi LP,

Please find attachment.

Both Formulas(Countif and Countifs) are suitable for the data.

Regards,
subhash Kumar


Attached Files
.xlsx   Sample file-1(countif and countifs).xlsx (Size: 15.32 KB / Downloads: 14)
  Reply
#6
(19-Jul-2017, 05:56 PM)Subhash Kumar Wrote: Hi LP,

Please find attachment.

Both Formulas(Countif and Countifs) are suitable for the data.

Regards,
subhash Kumar

Thanks Subhash,

But how to get count value without selection of cell, it means write this A65 Samsung 40 Smart" into the formula.

(19-Jul-2017, 05:04 PM)Anil Kumar Pal Wrote:
(19-Jul-2017, 04:18 PM)LB Vishwakarma Wrote:
(14-Jul-2017, 07:52 PM)Vivekananda Sinha Wrote: Please attach a sample excel file.

File Attached

Hi LB,

Please check attached response, I hope this will resolve your question.
Thank Anil,

But how to get count value without selection of cell, it means write this A65 Samsung 40 Smart" into the formula.
  Reply
#7
Please check the desired formula.


Attached Files
.xlsx   Sample file.xlsx (Size: 10.25 KB / Downloads: 13)
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Reply
#8
(24-Jul-2017, 12:26 PM)Vivekananda Sinha Wrote: Please check the desired formula.

Thank you very much sir
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula Query: Countifs : Name Search List @m!t $@!n! 1 1,708 05-Aug-2018, 05:24 PM
Last Post: Vivekananda Sinha
  Formula Countif & Sumif Gaurav Agarwal 2 2,445 30-Jun-2017, 11:20 AM
Last Post: Gaurav Agarwal
  Formula Sumifs Countifs and Averageifs function Sanjeev Gupta 2 2,847 03-May-2017, 08:59 PM
Last Post: Laxman

Forum Jump:


Users browsing this topic: 1 Guest(s)