Re: SUMPRODUCT problem
Tech-Archive recommends: Fix windows errors by optimizing your registry
Maybe checking those ranges using =count() or =counta().
To check for numeric entries:
=if(and(count(b84:h84)>0,count(j84:p84)>0),i84-q84,"no entries")
to check for any entries:
=if(and(counta(b84:h84)>0,counta(j84:p84)>0),i84-q84,"no entries")
Brian Clarke wrote:
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.
--
Dave Peterson
.
Relevant Pages
- Re: Solving the lib mismatch problem
... This section is pointed to by an entry in the section table with the ... The number of entries in the table is determined by DT_VERDEFNUM. ... This is an index into the string section referenced in the section ... Offset in the string section reference by the link in the section ...
(comp.unix.programmer) - Hollywood Book Festival - Call For Entries
... 2006 Hollywood Book Festival - Call for Entries ... Hollywood Book Festival submissions cannot be returned. ... Each entry package must contain the official entry form or facsimile, ... Applications must be accompanied by a non-refundable entry fee via ...
(alt.fan.harry-potter) - Hollywood Book Festival - Call For Entries
... 2006 Hollywood Book Festival - Call for Entries ... Hollywood Book Festival submissions cannot be returned. ... Each entry package must contain the official entry form or facsimile, ... Applications must be accompanied by a non-refundable entry fee via ...
(misc.writing) - Hollywood Book Festival - Call For Entries
... 2006 Hollywood Book Festival - Call for Entries ... Hollywood Book Festival submissions cannot be returned. ... Each entry package must contain the official entry form or facsimile, ... Applications must be accompanied by a non-refundable entry fee via ...
(rec.arts.sf.starwars.misc) - Hollywood Book Festival - Call For Entries
... 2006 Hollywood Book Festival - Call for Entries ... Hollywood Book Festival submissions cannot be returned. ... Each entry package must contain the official entry form or facsimile, ... Applications must be accompanied by a non-refundable entry fee via ...
(rec.arts.sf.written) |
|
