SUMPRODUCT problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Brian Clarke" <bxxcfilm@xxxxxxxxxxxxxxxx>
Date: Tue, 10 Jul 2007 11:10:16 +0100

I have a list where columns B - H are totaled in column I, and columns J - P
totaled in column Q. In column R, I want to show the difference between I
and Q, but only if there is at least one entry in cols B - H, AND at least
one entry in cols J - P.

I worked out this, which ought to work but doesn't.

=SUMPRODUCT((SUM(J84:P84="")<7)*(SUM(B84:H84="")<7)*(I84-Q84))

Where am I going wrong? This formula returns the difference between I and Q,
regardless of whether all the entries in B - H and J - P are blank.

.

Follow-Ups:
- Re: SUMPRODUCT problem
  - From: Dave Peterson
- Re: SUMPRODUCT problem
  - From: Stefan Holz

Prev by Date: Runtime Error in Excel 2007
Next by Date: I cant sum the values in cells!!
Previous by thread: Runtime Error in Excel 2007
Next by thread: Re: SUMPRODUCT problem
Index(es):
- Date
- Thread

Relevant Pages

Re: SUMPRODUCT problem
... (there's no email, no snail mail, but somewhere should be gmail in my ... AND at least one entry in cols J - P. ...
(microsoft.public.excel)
Re: SUMPRODUCT problem
... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... AND at least one entry in cols J - P. ...
(microsoft.public.excel)
Re: SUMPRODUCT problem
... To check for numeric entries: ... Brian Clarke wrote: ... one entry in cols J - P. ...
(microsoft.public.excel)
Re: SUMPRODUCT problem
... I and Q, but only if there is at least one entry in cols B - H, AND at ... regardless of whether all the entries in B - H and J - P are blank. ...
(microsoft.public.excel)
Re: SUMPRODUCT problem
... one entry in cols J - P. ... regardless of whether all the entries in B - H and J - P are blank. ...
(microsoft.public.excel)