Thread: User defined search and calculate

Hi All,

Please forgive me if this is the wrong forum but I need some help from some Guru's..

I want to add a search box/ cell on a spreadsheet that the user can define the variable in. The function would then be to check a range of cells (which I would designate) for the varriable the user has entered, calculate the number of times the variable is found within the cell range and then present the answer. To make this a little more easier to understand.. I have a spreadsheet setup based on an audit tool I use at work. Part of the data is the initials of staff involved in aspects of the audit data - I would like to be able to search for a set of initials e.g. PT, across a cell range and then be told how many times PT has been found.

I have some understanding of how functions work but no VBA or MACRO expereince.. Any help or advice greatly appreciated.

Thanks.

Hi and welcome to the board

Without seeing your data, at first glance a COUNTIF function might suffice where the user enters is value in a cell somewhere

Maybe post a sample sheet of your data

Is this what you want? (see attached)

I created a list of staff members on sheet 2 and a validation in A12