Hey,
So i am struggling to get the result I'm after using the 'countifs' function (a new function to me)
Essentially i have an excel doc with a list of events and potential visitors (from a drop down) to these events and i need to track which visitors attended which events. eg below
Event LOCATION V1 V2
FMTPE Cheshunt Bob
FMTPE Reading
FMTPE Newcastle Bob Sue
FMTPE Bristol Sue Bob
BTI Marlow
JTD Cheshunt
JTD Reading
JTD
JTD Bristol
I can largely achieve this with a pivot table, however on occasion there will be more than 1 visitor which i need to account for and total regardless of which column they appear in.
So after searching on here, i decided to abandon the pivot table and utilise the countifs function.
I'm aiming to achieve something with an output similar to below:
Visitor FMTPE BTI
Bob 3 0
Sue 2 0
However whenever i run the countifs function it only seems to count the Visitor 1 column.
I have attached an example document, but essentially i am asking it to count if it matches the event name and the name of the person.
I am using office 2010
Hope someone can correct my most likely obvious error.
Thanks in advance
JD
Bookmarks