Hi Angie,

For SUMPRODUCT try:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

But don't you mean VLOOKUP? if so try the Excel Help files

HTH

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"angie" wrote in message
...
I believe I need a Sumproduct formula...do you know how to do those?

"Sandy Mann" wrote:

What do you mean by:

I need on sheet 1, column C, to populate the health rate based on the
criteria entered, 'M/F' and 'age'.

What form does the health rate take?

Regards

Sandy
--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"angie" wrote in message
...
On sheet 1, column B, Line 27, I have to enter 'M' or 'F'.
On sheet 1, column B, Line 28, I enter an age. '54'.
I need on sheet 1, column C, to populate the health rate based on the
criteria entered, 'M/F' and 'age'.
The health rates are on sheet 3.
Does this make sense?
Can anyone help me?
I am still learning this program.
Thanks