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