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 *