Can I reference part of a formula

**scudo** · 06-02-2015, 05:09 PM

Probably not the correct terminology. I am currently using `find / replace` to do this, which does do the job satisfactorily.

Formula: COUNTIF(Apr!E:E,"John") Ok one can see this adds up the entries for John in sheet Apr, column E

As there are several names, Mary, Jean etc and many entries for each name I just wondered if part of the formula could be referenced from another sheet, something like COUNTIF(Apr!E:E,"=names! B6")

It is not an issue for me but thought I would ask the question if it were possible, I couldnt find anything on google.

Thank you

**oeldere** · 06-02-2015, 05:12 PM

Yes, that is possible.

You get better help, if you add a small excel file, without confidential information.

Please also add the expected result in the file.

**teylyn** · 06-02-2015, 05:12 PM

Hello,

yes, you can reference a cell instead of a string. Just use

=COUNTIF(Apr!E:E,names!B6)

Make sure there are no blanks between the sheet name and the cell reference, just the ! sign.

cheers, teylyn

**scudo** · 06-02-2015, 05:45 PM

Many thanks for that solution. I have been building this workbook for the last 6 weeks for my wife to use at work and I will be changing names in formulas many times as staff changes are made...You have just made my life one heck of a lot easier.

Thank you