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 Query
former_student
Posts: 509 Forumite
in Techie Stuff
Hi All,
I want to perform a county function on Excel 07 but it doesn't seem to work.
I have a list of week numbers, along with a list of results, What I want is to be able to filter by each week number and count the accourances for results. So for example if for week 37 there are 10 results, I want the figure 10 returned, howeve at present when I filter by week number the count returned for that week includes all the weeks. Can anyone help with this?
Thanks in advance.
I want to perform a county function on Excel 07 but it doesn't seem to work.
I have a list of week numbers, along with a list of results, What I want is to be able to filter by each week number and count the accourances for results. So for example if for week 37 there are 10 results, I want the figure 10 returned, howeve at present when I filter by week number the count returned for that week includes all the weeks. Can anyone help with this?
Thanks in advance.
0
Comments
-
Sounds like a job for COUNTIF():
http://office.microsoft.com/en-us/excel-help/use-the-countifs-function-in-excel-2007-to-analyze-data-HA010236993.aspxStompa0 -
The SUBTOTAL() function can calculate the number of rows currently shown in a filtered table. Use the formula =SUBTOTAL(2,datarange) .0
-
Assuming week numbers in column A and the counter in B and then the data in subsequent columns.
Working on row 4;
=COUNTIF(c4:z4,">0")0
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
- 603K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards