Insert the content of a cell into formula?

		Microsoft Office Forums > Microsoft Excel > Excel
Insert the content of a cell into formula?

FAQ

Thread Tools

Display Modes

08-27-2012, 05:18 AM

Pecoflyer

Windows 7 64bit Insert the content of a cell into formula?

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

try

Code:

=countifs(.....,"*"&E1&"*")

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Chosen option of drop-down changes another cell content	Weed	Word	1	01-26-2012 02:44 PM
Naming a cell then linking with a certain amount of charachters looses content.	shabbaranks	Excel	1	12-27-2011 01:06 AM
using a cell content as a string with COUNTIF	geoffm	Excel	1	08-16-2011 11:31 AM
How can I delete the content of a cell in column if the cell value is more than 1000?	Learner7	Excel	2	06-27-2011 05:44 AM
Cell content splits	Mahen	Excel	2	05-15-2011 01:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:39 AM.