In message <[log in to unmask]>, Jerry
Fochtman <[log in to unmask]> writes
>Thought I'd tap into the wealth of knowledge on this list to see if someone
>can help with building a formula which which is probably fairly easy but my
>mind has gone blank....
>
>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...
>
>TIA!

From the Excel Help, *exactly* what you need:

SUMIF

Adds the cells specified by a given criteria.

Syntax

SUMIF(range,criteria,sum_range)

Range   is the range of cells you want evaluated.

Criteria   is the criteria in the form of a number, expression, or text
that defines which cells will be added. For example, criteria can be
expressed as 32, "32", ">32", "apples".

Sum_range   are the actual cells to sum.

Remarks

The cells in sum_range are summed only if their corresponding cells in
range match the criteria.

If sum_range is omitted, the cells in range are summed.

Example
            A                             B
        Property Value               Commission
1       100,000                           7,000
2       200,000                          14,000
3       300,000                          21,000
4       400,000                          28,000

Formula                         Description (Result)

=SUMIF(A2:A5,">160000",B2:B5)   Sum of the commissions for
                                property values over 160,000
                                        (63,000)



--
Roy Brown        'Have nothing in your houses that you do not know to be
Kelmscott Ltd     useful, or believe to be beautiful'  William Morris

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