|
|
#1
08-27-2012, 05:06 AM
|
|||
|
|||
Insert the content of a cell into formula?
Hello
As you can see attahced, I need to insert the content of E1 cell into formula. I could do it by writing "ay" into formula but what I want is get the content from a cell. Can you give me the correct formula? Thanks, 
|
|
#2
08-27-2012, 05:18 AM
|
||||
|
||||
|
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
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Linear Mode
