Hi
Please see the attached spreadsheet.
Without using a pivot table, i want to be able to perform a count function where it counts all the people referred in January, February etc from each of the areas, Sheffield, Barnsley etc..
Is this possible?
Thanks
Paul
Last edited by Lazor78; 04-26-2012 at 11:05 AM. Reason: SOLVED
Hi Paul
My idea, using a helper(and hidden column B)is this.
In B2 and copy down, use this.
In Column H(starting in H2) copy the locations names.
Please Login or Register to view this content.
In I2, use this.
This is for January. Same for the other months.Please Login or Register to view this content.
Is this what are you looking for?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Did you want Jan 2011 grouped with Jan 2012?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Assuming "Yes", With Location in H3 going down and Month values (1-12) in I2:T2
In I3 dragged across and down
=SUMPRODUCT(--($E$2:$E$11=$H3),--(MONTH($F$2:$F$11)=I$2))
Does that work for you?
Thanks thats sorted it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks