Hi,
Can someone please help, I have ages on a seperate tab "Data" column E and areas on the same tab column A, what I'm trying to do is count all 18-21 y.o. for each area, but I can't see what is wrong with the formula below.
=COUNTIFS(Data!A:A,B1,Data!E:E,">=18",Data!E:E,"<=21")
many thanks
Last edited by Clash; 07-13-2010 at 09:52 AM.
Are you sure the items in column A match exactly with B1 (i.e. spelling, no extra spaces in cell, etc.).
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I've just had a look and they match exactly, but still no change.
Last edited by Clash; 07-13-2010 at 09:43 AM.
NBVC,
Thanks for the help, I have just re-wrote the formula and it now seems to want to work, once again thanks for looking.
Clash
If the formula doesn't seem to calculate properly when you change items.. check that your Automatic Calculations is not set to Manual.
Go to Office Button and click Excel Options.
Click on Formulas in the left pane and then select Automatic in the Calculation options section of the Right pane.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks