Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Formula Countif and countifs
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Countif and countifs
LB Vishwakarma
Lots of things to do

Fresher
Joined: Apr 2017
Posts: 8

Reputation: 0
#1
14-Jul-2017, 05:03 PM (This post was last modified: 18-Jul-2017, 01:29 PM by LB Vishwakarma.)
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"
  Find
  Reply
Vivekananda Sinha
The next innovation

Mentor
Joined: Apr 2017
Posts: 590

Reputation: 0

Location: Delhi
#2
14-Jul-2017, 07:52 PM
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
  Website   Find
  Reply
LB Vishwakarma
Lots of things to do

Fresher
Joined: Apr 2017
Posts: 8

Reputation: 0
#3
19-Jul-2017, 04:18 PM
(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)
  Find
  Reply
Anil Kumar Pal
Lots of things to do

Fresher
Joined: Apr 2017
Posts: 25

Reputation: 0
#4
19-Jul-2017, 05:04 PM
(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)
  Find
  Reply
Subhash Kumar
Lots of things to do

Fresher
Joined: May 2017
Posts: 5

Reputation: 0
#5
19-Jul-2017, 05:56 PM
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)
  Find
  Reply
LB Vishwakarma
Lots of things to do

Fresher
Joined: Apr 2017
Posts: 8

Reputation: 0
#6
21-Jul-2017, 11:40 AM (This post was last modified: 21-Jul-2017, 11:41 AM by LB Vishwakarma.)
(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.
  Find
  Reply
Vivekananda Sinha
The next innovation

Mentor
Joined: Apr 2017
Posts: 590

Reputation: 0

Location: Delhi
#7
24-Jul-2017, 12:26 PM
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
  Website   Find
  Reply
LB Vishwakarma
Lots of things to do

Fresher
Joined: Apr 2017
Posts: 8

Reputation: 0
#8
24-Jul-2017, 12:31 PM
(24-Jul-2017, 12:26 PM)Vivekananda Sinha Wrote: Please check the desired formula.

Thank you very much sir
  Find
  Reply


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

Forum Jump:


Users browsing this topic: 1 Guest(s)