| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect II
Is it possible to combine the formula
=COUNT.IF($B$5:$B$44;"*("&$AN5&")*") with INDIRECT in order to change the 44 in B44 into any (line-)number? The numbers will be placed in cell AO37. Thank you. -- Felix |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect II
You could use
=COUNTIF(OFFSET(B5,0,0,$AM5,1);"*("&$AN5&")*") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Felix" wrote in message ... Is it possible to combine the formula =COUNT.IF($B$5:$B$44;"*("&$AN5&")*") with "INDIRECT" in order to change the 44 in B44 into any (line-)number? The numbers will be placed in cell AO37. Thank you. -- Felix |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect II
Sorry, I cannot get it...
Maybe I should have explained better: in the formula =COUNT.IF($B$5:$B$44;"*("&$AN5&")*") what changes is the 44 (line) I need this number used in the formulae to be in cell AO37. Sorry for the confusion. -- Felix "Bob Phillips" wrote: You could use =COUNTIF(OFFSET(B5,0,0,$AM5,1);"*("&$AN5&")*") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Felix" wrote in message ... Is it possible to combine the formula =COUNT.IF($B$5:$B$44;"*("&$AN5&")*") with "INDIRECT" in order to change the 44 in B44 into any (line-)number? The numbers will be placed in cell AO37. Thank you. -- Felix |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect II
That should work fine
=COUNTIF(OFFSET(B5,0,0,$AO37,1);"*("&$AN5&")*") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Felix" wrote in message ... Sorry, I cannot get it... Maybe I should have explained better: in the formula =COUNT.IF($B$5:$B$44;"*("&$AN5&")*") what changes is the 44 (line) I need this number used in the formulae to be in cell AO37. Sorry for the confusion. -- Felix "Bob Phillips" wrote: You could use =COUNTIF(OFFSET(B5,0,0,$AM5,1);"*("&$AN5&")*") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Felix" wrote in message ... Is it possible to combine the formula =COUNT.IF($B$5:$B$44;"*("&$AN5&")*") with "INDIRECT" in order to change the 44 in B44 into any (line-)number? The numbers will be placed in cell AO37. Thank you. -- Felix |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect II
Hi Bob,
I could make it work, somehow...but I have to enter the line plus 1! This means that the range is one line shorter. No idea why. I can live with that, however, I simply use cell AO38 as the input and in cell AO37 I use the formula =AO38+1. -- Many thanks Felix "Bob Phillips" wrote: That should work fine =COUNTIF(OFFSET(B5,0,0,$AO37,1);"*("&$AN5&")*") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Felix" wrote in message ... Sorry, I cannot get it... Maybe I should have explained better: in the formula =COUNT.IF($B$5:$B$44;"*("&$AN5&")*") what changes is the 44 (line) I need this number used in the formulae to be in cell AO37. Sorry for the confusion. -- Felix "Bob Phillips" wrote: You could use =COUNTIF(OFFSET(B5,0,0,$AM5,1);"*("&$AN5&")*") -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Felix" wrote in message ... Is it possible to combine the formula =COUNT.IF($B$5:$B$44;"*("&$AN5&")*") with "INDIRECT" in order to change the 44 in B44 into any (line-)number? The numbers will be placed in cell AO37. Thank you. -- Felix |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
| Can I use INDIRECT.EXT for this? | Excel Worksheet Functions | |||
| INDIRECT !@%? | Excel Worksheet Functions | |||
| Help with INDIRECT() | Excel Discussion (Misc queries) | |||
Linear Mode
