|
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 04:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com