OGE:

If you are testing for a single condition in Column A, you can use the
SUMIF() function. The online help provides full documentation.
Alternatively, begin the formula, "=sumif(" and then press CTRL-A. Follow
the prompts.

=Mac=

"oldgrayelf" wrote in message
...
I want to sum the values in column B using indicators in column A as the
condition. For instance, all values in column B matching the "1"
indicator
in column A should be summed, and no others. Other indicators in column A
are 2, 3, etc. I know this takes an array formula, but I don't remember
how
to do it.