Hi All,

I'm sure that I asked this before, but the formula messed up and I
can't get it back again.

I tried finding my previous post - it was within the last three or
four days, but I can't find it. First question - what's the best way
to find your own posts?

Second question - how to I change the end of this:

{=SUMPRODUCT(--($B$6:$B$503=F$569),--($B$6:$B$503<G$569),--($Y$6:$Y
$503=$B584),$H$6:$H$503)}

To ,$H$6:$R$503) i.e. the last H to an R ---- without getting the
#VALUE! error.

I'm sure I asked this before because one of the formulas say:

{=SUMPRODUCT(--($B$6:$B$503=G$569),--($B$6:$B$503<H$569),--($Y$6:$Y
$503=$B584),(#REF!)+(#REF!))}

but I can't remember what went in the (#REF!) spots.

Thanks again!!!!

Michele

1. Remove the braces from around your formula (ie, don't use
Ctrl-Shift-Enter to enter it, just use Enter. Sumproduct is not an array
function).
2. All ranges in a Sumproduct function must be the same size. You can have
H6:R503 is a lot bigger than the rest of your ranges, hence the #Value
error.

Regards,
Fred

"mjones" wrote in message
...
Hi All,

I'm sure that I asked this before, but the formula messed up and I
can't get it back again.

I tried finding my previous post - it was within the last three or
four days, but I can't find it. First question - what's the best way
to find your own posts?

Second question - how to I change the end of this:

{=SUMPRODUCT(--($B$6:$B$503=F$569),--($B$6:$B$503<G$569),--($Y$6:$Y
$503=$B584),$H$6:$H$503)}

To ,$H$6:$R$503) i.e. the last H to an R ---- without getting the
#VALUE! error.

I'm sure I asked this before because one of the formulas say:

{=SUMPRODUCT(--($B$6:$B$503=G$569),--($B$6:$B$503<H$569),--($Y$6:$Y
$503=$B584),(#REF!)+(#REF!))}

but I can't remember what went in the (#REF!) spots.

Thanks again!!!!

Michele

Here's your other post:

http://www.microsoft.com/communities...f-47e20c208aad

--
Biff
Microsoft Excel MVP


"mjones" wrote in message
...
Hi All,

I'm sure that I asked this before, but the formula messed up and I
can't get it back again.

I tried finding my previous post - it was within the last three or
four days, but I can't find it. First question - what's the best way
to find your own posts?

Second question - how to I change the end of this:

{=SUMPRODUCT(--($B$6:$B$503=F$569),--($B$6:$B$503<G$569),--($Y$6:$Y
$503=$B584),$H$6:$H$503)}

To ,$H$6:$R$503) i.e. the last H to an R ---- without getting the
#VALUE! error.

I'm sure I asked this before because one of the formulas say:

{=SUMPRODUCT(--($B$6:$B$503=G$569),--($B$6:$B$503<H$569),--($Y$6:$Y
$503=$B584),(#REF!)+(#REF!))}

but I can't remember what went in the (#REF!) spots.

Thanks again!!!!

Michele

http://groups.google.co.uk/groups/se...thors=m jones
--
David Biddulph


"mjones" wrote in message
...
....
I tried finding my previous post - it was within the last three or
four days, but I can't find it. First question - what's the best way
to find your own posts?
....