No it doesn't have to be entered as an array formula as it is a formula that
works on arrays, like SUM.

Why bother with a macro? You could set it up and print preview as normal.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Chris Hankin" wrote in message
...

Thanks Bob for your help, much appreciated.

I looked up the function SUMPRODUCT in the Excel help section. It
mentions arrays. Do I need to enter the formulas in as array formulas?

Can I run this as a macro?

I'd like to run it as a macro if possible and output to a print-preview.

Kind regards,

Chris.

P.S. I very much a newbie - please be gentle.


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!