Hi,
I have no doubt this is something really simple however it has me stumped,
I have two sheets one with a list containing 3 different words and on another page a section which is a summary.
How can I make the count but also keep it dynamic so if more cells were added it would keep toting it up.
I have enclosed a sample below
Thanks,
Daniel1234
Last edited by Daniel1234; 03-10-2010 at 04:57 AM.
tRY:
=COUNTIF(Sheet1!D:D,C4)
Copied down.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Ideally would need
Live: 5
Pending: 25
Dead: 8
As a summary
Sorry for being ignorant about this.
Daniel1234
Can you explain why?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
This is 1 column of 15 which contains sales data, the data is broken up into diffrent catagories one of which is their status.
The document is huge and i wanted to make page 1 a bit of an interface with quick easy to read referances to the rest of the document.
So in this small part I want at a glance to be able to see exactly how many accounts are active (live) how many are ongoing and how many are closed.
I understand that, but with the sample list you supplied how do you get the numbers you are expecting, rather than the numbers my formulae are giving...
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
it was just an example with those numbers. I tried usuing your formula in a number of ways but i only got 0's coming up. is there any chance you could attach it to the spreadsheet?
See attached.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Okay that works perfectly thank-you so much for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks