We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel help please! - COUNT function
Milky_Mocha
Posts: 1,066 Forumite
in Techie Stuff
Hi all
I'm trying to do something really simple but cannot figure it out.
I have two columns, one containing some cells with the word no and another containing some cells with the word yes.
All I want to do is have a running total of how many yeses and how many nos there are.
So far the best I can do is obtain the result in the bottom toolbar but that is not visible when printing.
Any ideas?
:-(
I'm trying to do something really simple but cannot figure it out.
I have two columns, one containing some cells with the word no and another containing some cells with the word yes.
All I want to do is have a running total of how many yeses and how many nos there are.
So far the best I can do is obtain the result in the bottom toolbar but that is not visible when printing.
Any ideas?
:-(
The reason people don't move right down inside the carriage is that there's nothing to hold onto when you're in the middle.
0
Comments
-
Use =COUNTIF where you want the running total to appear. For example =COUNTIF(A1 : A10,"yes")0
-
thanks for that. unfortunately it only seems to count numbers whereas my values are text.The reason people don't move right down inside the carriage is that there's nothing to hold onto when you're in the middle.0
-
Are you using COUNTIF? Not COUNT. COUNTIF counts text.0
-
Right the formula should be:
=countif(A1:A10, "Yes")
Subsitute the A1 and A10 for the range and the yes for what you want to count.0 -
In the previous post the angel was meant to be :1
-
not too sure what happened to jonny's post, but the point he was making was that countif will look for texts if in the formula you mark the text with speech marks so "yes" rather than yes.
Hope this works...1
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455.1K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards