HP3000-L Archives

January 2005, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: OT: Spreadsheet formula...
From:
Jerry Fochtman <[log in to unmask]>
Reply To:
Jerry Fochtman <[log in to unmask]>
Date:
Wed, 26 Jan 2005 09:14:47 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (78 lines) 
Have you tried something like:

=SUMIF(E3:E11,"Larry",D3:D11)+SUMIF(E3:E11,"Mike",D3:D11)+SUMIF(E3:E11,"John",D3:D11)



At 08:48 AM 1/26/2005 -0600, [log in to unmask] wrote:
>  I have a question regarding the SUMIF Function.  Using the example
>below.  I need to be able to add Mike John and Larry's totals to one
>cell.  Here is what I tried with no luck.
>
>=SUMIF(E3:E11,"=Larry""=Mike""=John",D3:D11)
>=SUMIF(E3:E11,"Larry""Mike""John",D3:D11)
>
>Neither of these work.
>
>Does anyone have any ideas as to how to get this to work?
>
>Thanks,
>Erik
>
>Larry Barnes wrote:
> > Here's what I sent Jerry and it seemed to work for him.  The formula
>is
> > below the to columns and is in Column D.
> > You must use double-quotes within the formula, single-quotes will
>give
> > you an error.
> >
> >
> >                (D)       (E)
> >                  20     Mike
> >                  33     John
> >                 100     Larry
> >                  93     Mike
> >                 755     Larry
> >                 153     Bill
> >                  32     Larry
> >                  46     John
> >                  88     Bill
> >                 =SUMIF(E3:E11,"=Larry",D3:D11)
> >
> >
> >
> > -----Original Message-----
> > From: Mark Wonsil [mailto:[log in to unmask]]
> > Sent: Thursday, November 04, 2004 6:44 AM
> > To: [log in to unmask]
> > Subject: Re: [HP3000-L] OT: Spreadsheet formula...
> >
> > HP-3000 Systems Discussion wrote:
> > > I'd like to sum the cell contents in column "A", but only if the
>value
> >
> > > in column "B"
> > > on the same row contains a specific value.   I know I can do
> > > this with a hidden column,
> > > but wondered if there was another technique...
> >
> > A hidden column with the IF function is certainly the way I would do
>it.
> > If you really want to avoid the extra column, you could write a VBA
> > function that returns the total.
> >
> > Mark W.
> >
> > * To join/leave the list, search archives, change list settings, *
> > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
> >
> > * To join/leave the list, search archives, change list settings, *
> > * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2