"C" has an ASCII code of 67 and may be expressed as CHAR(67), ROW() is
the current row
presuming your formula Sheet18.C$row * Sheet1.H1 is in row 1
C=CHAR(66+ROW())=CHAR(67) in row 1
D=CHAR(66+ROW())=CHAR(68) in row 2
....
INDIRECT function is used for constructing addresses of text strings
thus "Sheet18!C$" may be expressed as INDIRECT("Sheet18!"&CHAR(66+ROW
())...
& is used to concatenate text strings

HIH


On 20 Maj, 08:57, Chris wrote:
I'm not sure of a couple things here... Â*First, can you break this down for
me, because I may be able to use it then. Â*I'm just unfamiliar with these
functions still.

Thanks again.



"Jarek Kujawa" wrote:
would this:

=INDIRECT("Sheet18!"&CHAR(66+ROW())&ROW())*Sheet1! H1

help?

then drag/copy down

On 20 Maj, 06:36, Chris wrote:
Well, as the title says, I've got a hard function, and I'm at a loss, so here
goes what I'm trying to code.

This function will be on Sheet20.

Where cell "F4" is found in column "M" of Sheet18, I need it to multiply
that row's column "C" by the value of Sheet1's "H1"... Let me try and type it
another way.

If Sheet20.$$ == Sheet18.M$row Â*<--- I'm implying that I need all rows where
Sheet18's column "M" has the same value as a value on Sheet20.

Â* Â* Â* Â* Â* Sheet18.C$row * Sheet1.H1
Â* Â* Â* Â* Â* Sheet18.D$row * Sheet1.H2
Â* Â* Â* Â* Â* Â* Â* Â* Â*.
Â* Â* Â* Â* Â* Â* Â* Â* Â*.
Â* Â* Â* Â* Â* Sheet18.L$Row * Sheet1.H10

Add all those together, and that's the number I want to display.

Â*The reason I need a function for it, is because I have two worksheets where
this will be done 365 times (it's for a calendar).

Any help is appreciated... As I said earlier, I'm at a loss here.

Thanks- Ukryj cytowany tekst -

- Pokaż cytowany tekst -