| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I define a range using values in cells?
I want to define a range using values in two cells. Let's say cell B40
contains information about the cell at which the range should start (it says for example: cell B101) and cell B56 contains information about the cell at which the range should stop (it says for example: cell B256). Now I want to count specific values within this range. Can I define the range using the information in cell B40 and cell B56 with a formula? I hope anyone can help me, it would save me a lot of work. Matthieu |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I define a range using values in cells?
=COUNTIF(INDIRECT(B40&":"&B56),yourValue)
HTH -- AP "Matthieu de Wit" <Matthieu de a écrit dans le message de ... I want to define a range using values in two cells. Let's say cell B40 contains information about the cell at which the range should start (it says for example: cell B101) and cell B56 contains information about the cell at which the range should stop (it says for example: cell B256). Now I want to count specific values within this range. Can I define the range using the information in cell B40 and cell B56 with a formula? I hope anyone can help me, it would save me a lot of work. Matthieu |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I define a range using values in cells?
Hi there Ardus Petrus, this works perfect for me. Thank you very much!!
Matthieu "Ardus Petus" wrote: =COUNTIF(INDIRECT(B40&":"&B56),yourValue) HTH -- AP "Matthieu de Wit" <Matthieu de a écrit dans le message de ... I want to define a range using values in two cells. Let's say cell B40 contains information about the cell at which the range should start (it says for example: cell B101) and cell B56 contains information about the cell at which the range should stop (it says for example: cell B256). Now I want to count specific values within this range. Can I define the range using the information in cell B40 and cell B56 with a formula? I hope anyone can help me, it would save me a lot of work. Matthieu |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Count occurances in range of cells | Excel Worksheet Functions | |||
| Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
