Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculate yes

Status
Not open for further replies.
ajaykr333

ajaykr333

Programmer
Oct 22, 2003
4
IN
Dear,
I have an spread sheet. In this there is colunm where it it written 'Yes', 'No' & 'spaces'
I want to count number of yes and number of no and number of not written means spaces.

Can anyone suggest me what fuction i should use to get my answer.
 
Sort by date Sort by votes
Use the =countif(....) function.

Help describes it quite well.
 
Upvote 0 Downvote
Thanks,
But In COUNTIF fuction what does criteria means. What shoul i write In That.
 
Upvote 0 Downvote
ajaykr333,
Column Count Formula
Yes 6 =yes =COUNTIF(H:H,"yes")
Yes 5 =no =COUNTIF(H:H,"no")
no 2 =space =COUNTIF(H:H," ")
no 2 =blank =COUNTIF(H:H,"")
yes

yes

no
yes

no
tav
yes

no
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Pivot Table - Calculated Fields / Different From 1
Replies
12
Views
202
combo
combo
cpjeffm
  • Locked
  • Question
Excel - calculate state, county and city tax amounts from total tax amount 1
Replies
3
Views
60
SkipVought
S
mejiaks
  • Locked
  • Question
Calculate percentage between to column values in pivot table
Replies
1
Views
52
mejiaks
mejiaks
elsenorjose
  • Locked
  • Question
Calculate a sum based on range criteria
Replies
6
Views
59
SkipVought
S
mejiaks
  • Locked
  • Question
Calculate % of a Row Grand Total
Replies
2
Views
50
combo
combo

Part and Inventory Search

Sponsor

Back
Top