Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using Number from Cell for Celladress
Hi,
For Example in Cell A1 is the Number 1234 and in Cell B1 is the Number 5678. How can I use the Number in the Cells A1 and B1 to Adress other Cells. For example I want to Count the Cells with content from D1234 to D5678, how can I put that into a formula whitch uses the Content from the Cells A1 and B1 for adressing. In Cell C1 I want to have something like this: =Count("D"+Content(A1):"D"+Content(B1)) It that possible? Markus http://home.arcor.de/maqqusz/wetterr...elquestion.PNG |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
using Number from Cell for Celladress
Markus
=COUNT(INDIRECT("D" & A1 & ":D" & B1)) =SUM(INDIRECT("D" & A1 & ":D" & B1)) Regards Trevor "maqqusz" wrote in message ... Hi, For Example in Cell A1 is the Number 1234 and in Cell B1 is the Number 5678. How can I use the Number in the Cells A1 and B1 to Adress other Cells. For example I want to Count the Cells with content from D1234 to D5678, how can I put that into a formula whitch uses the Content from the Cells A1 and B1 for adressing. In Cell C1 I want to have something like this: =Count("D"+Content(A1):"D"+Content(B1)) It that possible? Markus http://home.arcor.de/maqqusz/wetterr...elquestion.PNG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying the number of a custom formatted number cell | Excel Discussion (Misc queries) | |||
Random cell/number and dont repeat selected cell/number | Excel Discussion (Misc queries) | |||
formatting cell number based on previous cell number | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Creating a certain number of entries based on a number in a cell | Excel Worksheet Functions |