You'll get that error if your arrays contain a non-numeric header. If row 15
contains the name of your field, for example.
"Bob Phillips" wrote:
Show us the SUMIF variation that works, and we might be able to figure it.
--
HTH
Bob Phillips
"benb" wrote in message
...
There are no errors, but I am still coming up with the #VALUE! error
message
using SUMPRODUCT(). I've tried a few things, changing the formula and
using
a dummy dataset, but I couldn't figure out why I was getting the error.
Fortunately I found a SUMIF variation that worked instead, but I'm still
curious what's causing the error in SUMPRODUCT.
"Bob Phillips" wrote:
Personally, I would fix the data and ensure there are no errors there.
--
HTH
-------
Bob Phillips
"Dave R." wrote in message
...
If any of the cells have VALUE errors, you'll get that message. Blank
cells
are OK. If the cell contains some text, you'll be fine with the way
your
formula is written.
You can count error messages in a range with;
=SUMPRODUCT(--ISERROR(A1:A100))
"benb" wrote in message
...
I have a column of dates and a corresponding column of values that
are
actually functions converting a foreign currency amount into USD. I
want
to
create a month-to-date total in a single cell by using SUMPRODUCT.
What
I
am
using is:
=SUMPRODUCT(--(YEAR($A$15:$A$1000)=YEAR($C$7)),--(MONTH($A$15:$A$1000)=MONTH
($C$7)),$B$15:$B$1000)
But I am getting the #VALUE! error message. Some of the cells in
the
dates
array are blank, and there may be a cell in the values array that
has an
error because the values are functions themselves. How can I fix
this?
If I
can assure that none of the cells in the value array have errors
will
that
make it easier?
|