While you are waiting for Jarek to respond to you, I have a couple of
questions of my own for you. I found your original description a little bit
"fuzzy" and, from the wording of Jarek's response, I'm guessing he did too.
What is "fixed" in your specified data and what is "changeable"? By that I
mean... will the formula we develop only be used in a single cell or will it
be copied to other cells on Sheet20? If copied, what is "fixed" in the
calculation and what is "changeable"? Again, by that I mean... is the value
in Sheet20!F4 that you are having Column M of Sheet18 match always going to
be the value from Sheet20!F4, or will it be some other value when the
formula is copied? The columns C through L on Sheet18 for the "found rows"
is obviously fixed, but is the Column H (rows 1 through 10, which are fixed)
on Sheet 1 also fixed, or will this column letter change when the formula is
copied?

--
Rick (MVP - Excel)


"Chris" wrote in message
...
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