| Home | Articles | Register | Members | Search | Links |
 |
| Thread Tools | Display Modes |
|
Guest
Posts: n/a
|
I have a value of 20 in cell A1, how can I use this value in a formula.
E.g. COUNTA("D11  " & A1) - (I feel it should be similar to this )Sandy |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
=COUNTA(INDIRECT("D11
"&a1))-- Don Guillett Microsoft MVP Excel SalesAid Software (E-Mail Removed) "Sandy" <(E-Mail Removed)> wrote in message news:4011B2E9-7F93-44E8-A3DF-(E-Mail Removed)... >I have a value of 20 in cell A1, how can I use this value in a formula. > > E.g. COUNTA("D11 " & A1) - (I feel it should be similar to this )> > Sandy |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Hi Sandy
One way =COUNTA(D11:INDEX(D ,A1))-- Regards Roger Govier "Sandy" <(E-Mail Removed)> wrote in message news:4011B2E9-7F93-44E8-A3DF-(E-Mail Removed)... > I have a value of 20 in cell A1, how can I use this value in a formula. > > E.g. COUNTA("D11 " & A1) - (I feel it should be similar to this )> > Sandy |
|
|
|
|
|||
|
Guest
Posts: n/a
|
another
=COUNTA(D11:OFFSET(D11,0,0,a1)) -- Don Guillett Microsoft MVP Excel SalesAid Software (E-Mail Removed) "Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message news:7BE87F0D-ED99-4090-B087-(E-Mail Removed)... > Hi Sandy > > One way > =COUNTA(D11:INDEX(D ,A1))> > -- > Regards > Roger Govier > > "Sandy" <(E-Mail Removed)> wrote in message > news:4011B2E9-7F93-44E8-A3DF-(E-Mail Removed)... >> I have a value of 20 in cell A1, how can I use this value in a formula. >> >> E.g. COUNTA("D11 " & A1) - (I feel it should be similar to this )>> >> Sandy > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Don, Roger,
Thank you once again; as usual there is never just one way to do these things, which always makes it very interesting to see the variety of the solutions. Sandy "Sandy" <(E-Mail Removed)> wrote in message news:4011B2E9-7F93-44E8-A3DF-(E-Mail Removed)... > I have a value of 20 in cell A1, how can I use this value in a formula. > > E.g. COUNTA("D11 " & A1) - (I feel it should be similar to this )> > Sandy |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Don
This one seems to count from D11 30, whereas I was looking to count fromD11 20.I think it may be offsetting from the 11th row by the value of A1; 20 in my case. Sandy "Don Guillett" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > another > =COUNTA(D11:OFFSET(D11,0,0,a1)) > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > (E-Mail Removed) > "Roger Govier" <roger@technology4unospamdotcodotuk> wrote in message > news:7BE87F0D-ED99-4090-B087-(E-Mail Removed)... >> Hi Sandy >> >> One way >> =COUNTA(D11:INDEX(D ,A1))>> >> -- >> Regards >> Roger Govier >> >> "Sandy" <(E-Mail Removed)> wrote in message >> news:4011B2E9-7F93-44E8-A3DF-(E-Mail Removed)... >>> I have a value of 20 in cell A1, how can I use this value in a formula. >>> >>> E.g. COUNTA("D11 " & A1) - (I feel it should be similar to this )>>> >>> Sandy >> > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Try COUNTA("D11
" & $A$1)Sandy wrote: > I have a value of 20 in cell A1, how can I use this value in a formula. > > E.g. COUNTA("D11 " & A1) - (I feel it should be similar to this )> > Sandy |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| reference a range based on a cell value | william kossack | Excel Newsgroup | 2 | 03-29-2007 02:16 PM |
| How do I reference a RANGE inside a Cell Formula? | JimP | Excel Newsgroup | 1 | 09-25-2006 02:36 AM |
| use cell reference for named range | elf21 | Excel Newsgroup | 5 | 02-20-2006 12:32 AM |
| Absolute Cell Reference Across A Range | SamuelT | Excel Newsgroup | 5 | 11-08-2005 02:37 PM |
| More than 1 cell reference/range in formula | 0-0 Wai Wai ^-^ | Excel Newsgroup | 2 | 09-07-2005 08:32 AM |
Linear Mode
