Another Formula Question
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 |
Another Formula Question
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 |
Another Formula Question
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 |
Another Formula Question
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? .... |
All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com