why does this formula return a #VALUE! error
Yes, the "Left" coast, among these "dang" Liberals in the L.A. area.
Heck ... now I've revealed my politics as well as my address!<bg
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"Bob Phillips" wrote in message
...
00:08am. That means that you are on the West Coast?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"RagDyer" wrote in message
...
The above post was 4:08 PM my time.
What was your time of the post?
--
Regards,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Bob Phillips" wrote in message
...
BTW, I couldn't get the suggestion that you made to work, on the basis
that
the numbers returned the #VALUE, so trying to outsort it in a condition
made
no difference. Will re-try that also.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"RagDyer" wrote in message
...
I can't seem to get that to work Bob!
--
Regards,
RD
-------------------------------------------------------------------------
-
-
Please keep all correspondence within the NewsGroup, so all may benefit
!
-------------------------------------------------------------------------
-
-
"Bob Phillips" wrote in message
...
See RagDyer's response. Blank cells do not cause a problem, but
spaces
or
cells with zero-length strings do. You can circumvent with
=SUMPRODUCT((N(E103:P314))*(E98:P98="Project"))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"SteveC" wrote in message
...
Dave, assuming I have blank and text in the range the sumproduct
formula
is
pulling from, and that I can't change the ranges, is there anyway to
avoid
the associated error by modifying the sumproduct formula? Thanks.
Steve
C
"Dave Peterson" wrote:
Any errors in any of those cells?
And non-numeric data in the first range?
Dave F wrote:
Formula is: =SUMPRODUCT((E103:P114)*(E98:P98="Project"))
Should return 0. But I also get the error if there are values
greater
than
zero in the range which meet the criteria.
Thanks, Dave
--
Brevity is the soul of wit.
--
Dave Peterson
|